using System;
|
using System.Text;
|
using System.Data.SqlClient;
|
using System.Data;
|
using WIP_Models;
|
|
namespace WIP_DAL
|
{
|
/// <summary>
|
/// $ChinaComment$Êý¾Ý·ÃÎÊÀà
|
/// </summary>
|
public class $FilePrefixName$DAL
|
{
|
#region Add
|
|
/// <summary>
|
/// Ôö¼ÓÒ»Ìõ$ChinaComment$Êý¾Ý
|
/// </summary>
|
/// <param name="model">Òª²åÈëµÄ$ChinaComment$ʵÌå</param>
|
/// <param name="transModel">ÊÂÎñÀà</param>
|
/// <returns>²åÈëÉú³ÉµÄ×îÐÂÖ÷¼üÖµ</returns>
|
public int Add($EntityName$ model,TransactionModel transModel = null)
|
{
|
SqlParameter param_id = new SqlParameter();
|
param_id.ParameterName = "@id";
|
param_id.SqlDbType = SqlDbType.Int;
|
param_id.Direction = ParameterDirection.Output;
|
|
$AddSqlParameter$
|
|
int rowsAffected;
|
if (transModel != null)
|
{
|
DbHelperSQL.RunProcedure(transModel.conn,transModel.trans, "$AddProcName$", parameters, out rowsAffected);
|
}
|
else
|
{
|
DbHelperSQL.RunProcedure("$AddProcName$", parameters, out rowsAffected);
|
}
|
return (int)parameters[parameters.Length - 1].Value;
|
}
|
|
#endregion
|
|
#region Edit
|
|
/// <summary>
|
/// ¸üÐÂÒ»Ìõ$ChinaComment$Êý¾Ý
|
/// </summary>
|
/// <param name="model">Òª¸üеÄ$ChinaComment$ʵÌå</param>
|
/// <param name="transModel">ÊÂÎñÀà</param>
|
/// <returns>ÊÇ·ñ¸üгɹ¦</returns>
|
public bool Update($EntityName$ model,TransactionModel transModel = null)
|
{
|
$UpdateSqlParameter$
|
|
int rowsAffected = 0;
|
if (transModel != null)
|
{
|
DbHelperSQL.RunProcedure(transModel.conn,transModel.trans, "$UpdateProcName$", parameters, out rowsAffected);
|
}
|
else
|
{
|
DbHelperSQL.RunProcedure("$UpdateProcName$", parameters, out rowsAffected);
|
}
|
if (rowsAffected > 0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
|
#endregion
|
|
#region Del
|
|
/// <summary>
|
/// ɾ³ýÒ»Ìõ$ChinaComment$Êý¾Ý
|
/// </summary>
|
/// <param name="$PrimaryKey$">$PrimaryKeyDesc$</param>
|
/// <param name="transModel">ÊÂÎñÀà</param>
|
/// <returns>ÊÇ·ñɾ³ý³É¹¦</returns>
|
public bool Delete(string $PrimaryKey$,TransactionModel transModel = null)
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("DELETE FROM $TableName$ ");
|
strSql.Append(" WHERE $PrimaryKey$=@$PrimaryKey$");
|
SqlParameter[] parameters = {
|
new SqlParameter("@$PrimaryKey$", SqlDbType.NVarChar,50)
|
};
|
parameters[0].Value = $PrimaryKey$;
|
|
int rows = 0;
|
if (transModel != null)
|
{
|
rows = DbHelperSQL.ExecuteSql(transModel.conn, transModel.trans, strSql.ToString(), parameters);
|
}
|
else
|
{
|
rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
|
}
|
if (rows > 0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
|
#endregion
|
|
#region Enable
|
|
/// <summary>
|
/// ½ûÆôÓÃ$ChinaComment$Êý¾Ý
|
/// </summary>
|
/// <param name="$PrimaryKey$">$PrimaryKeyDesc$</param>
|
/// <param name="delFlag">½ûÓÃ1/ÆôÓÃ0</param>
|
/// <param name="lastModifier">×îºóÐÞ¸ÄÈË</param>
|
/// <param name="transModel">ÊÂÎñÀà</param>
|
/// <returns>ÊÇ·ñ½ûÆôÓóɹ¦</returns>
|
public bool Enable(string $PrimaryKey$, string delFlag, string lastModifier, TransactionModel transModel = null)
|
{
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append(" UPDATE $TableName$ SET delflag=@delFlag ");
|
strSql.Append(" ,lastModifier=@lastModifier ");
|
strSql.Append(" ,lastModifyTime=@lastModifyTime ");
|
strSql.Append(" WHERE $PrimaryKey$=@$PrimaryKey$");
|
SqlParameter[] parameters = {
|
new SqlParameter("@delFlag", SqlDbType.NVarChar,10) ,
|
new SqlParameter("@lastModifier", SqlDbType.NVarChar,20) ,
|
new SqlParameter("@lastModifyTime", SqlDbType.DateTime) ,
|
new SqlParameter("@$PrimaryKey$", SqlDbType.NVarChar,50)
|
};
|
parameters[0].Value = delFlag;
|
parameters[1].Value = lastModifier;
|
parameters[2].Value = DateTime.Now;
|
parameters[3].Value = $PrimaryKey$;
|
|
int rows = 0;
|
if (transModel != null)
|
{
|
rows = DbHelperSQL.ExecuteSql(transModel.conn, transModel.trans, strSql.ToString(), parameters);
|
}
|
else
|
{
|
rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
|
}
|
return rows > 0 ? true : false;
|
}
|
|
#endregion
|
|
#region QueryList(Page)
|
|
/// <summary>
|
/// »ñµÃ$ChinaComment$Êý¾ÝÁбí(·ÖÒ³)
|
/// </summary>
|
/// <param name="pageParam">·ÖҳʵÌåÊý¾Ý</param>
|
/// <returns>$ChinaComment$ÁбíDataSet</returns>
|
public DataSet GetModelListForPage(Query$Modulelogo$Param pageParam)
|
{
|
$QueryPageSqlParameter$
|
|
return DbHelperSQL.RunProcedure("$GetPageListProcName$", parameters, "pagetable");
|
}
|
|
#endregion
|
|
#region QueryList
|
|
/// <summary>
|
/// »ñµÃ$ChinaComment$Êý¾ÝÁбí
|
/// </summary>
|
/// <param name="strWhere">²éѯÌõ¼þ</param>
|
/// <returns>$ChinaComment$ÁбíDataSet</returns>
|
public DataSet GetList(string strWhere)
|
{
|
SqlParameter[] parameters = {
|
new SqlParameter("@strWhere", SqlDbType.NVarChar,500)
|
};
|
parameters[0].Value = strWhere;
|
return DbHelperSQL.RunProcedure("$GetListProcName$", parameters, "table");
|
}
|
|
#endregion
|
|
#region Query(Single)
|
|
/// <summary>
|
/// µÃµ½Ò»¸ö$ChinaComment$ʵÌå
|
/// </summary>
|
/// <param name="$PrimaryKey$">$PrimaryKeyDesc$</param>
|
/// <returns>$ChinaComment$ʵÌå</returns>
|
public $EntityName$ GetModel(string $PrimaryKey$)
|
{
|
SqlParameter[] parameters = {
|
new SqlParameter("@$PrimaryKey$", SqlDbType.VarChar,50)
|
};
|
parameters[0].Value = $PrimaryKey$;
|
|
DataSet ds = DbHelperSQL.RunProcedure("$GetSingleProcName$", parameters, "pagetable");
|
|
$EntityName$ model = new $EntityName$();
|
|
if (ds.Tables[0].Rows.Count == 1)
|
{
|
var dataRow = ds.Tables[0].Rows[0];
|
|
$ToSingleModel$
|
|
return model;
|
}
|
else
|
{
|
return null;
|
}
|
}
|
|
#endregion
|
|
#region Other
|
|
/// <summary>
|
/// ÊÇ·ñ´æÔÚ¸Ã$ChinaComment$¼Ç¼
|
/// </summary>
|
/// <param name="$PrimaryKey$">$PrimaryKeyDesc$</param>
|
/// <returns>ÊÇ·ñ´æÔÚ¸Ã$ChinaComment$¼Ç¼</returns>
|
public bool Exists(string $PrimaryKey$, int? id = null)
|
{
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("SELECT COUNT(1) FROM $TableName$");
|
strSql.Append(" WHERE ");
|
strSql.Append(" $PrimaryKey$ = @$PrimaryKey$ ");
|
if (id != null)
|
{
|
strSql.Append(" AND id <> " + id.ToString());
|
}
|
SqlParameter[] parameters = {
|
new SqlParameter("@$PrimaryKey$", SqlDbType.NVarChar,50) };
|
parameters[0].Value = $PrimaryKey$;
|
|
return DbHelperSQL.Exists(strSql.ToString(), parameters);
|
}
|
|
#endregion
|
|
}
|
}
|
