using System; using System.Text; using System.Data.SqlClient; using System.Data; using WIP_Models; namespace WIP_DAL { /// /// $ChinaComment$Êý¾Ý·ÃÎÊÀà /// public class $FilePrefixName$DAL { #region Add /// /// Ôö¼ÓÒ»Ìõ$ChinaComment$Êý¾Ý /// /// Òª²åÈëµÄ$ChinaComment$ʵÌå /// ÊÂÎñÀà /// ²åÈëÉú³ÉµÄ×îÐÂÖ÷¼üÖµ 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 /// /// ¸üÐÂÒ»Ìõ$ChinaComment$Êý¾Ý /// /// Òª¸üеÄ$ChinaComment$ʵÌå /// ÊÂÎñÀà /// ÊÇ·ñ¸üгɹ¦ 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 /// /// ɾ³ýÒ»Ìõ$ChinaComment$Êý¾Ý /// /// $PrimaryKeyDesc$ /// ÊÂÎñÀà /// ÊÇ·ñɾ³ý³É¹¦ 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 /// /// ½ûÆôÓÃ$ChinaComment$Êý¾Ý /// /// $PrimaryKeyDesc$ /// ½ûÓÃ1/ÆôÓÃ0 /// ×îºóÐÞ¸ÄÈË /// ÊÂÎñÀà /// ÊÇ·ñ½ûÆôÓóɹ¦ 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) /// /// »ñµÃ$ChinaComment$Êý¾ÝÁбí(·ÖÒ³) /// /// ·ÖҳʵÌåÊý¾Ý /// $ChinaComment$ÁбíDataSet public DataSet GetModelListForPage(Query$Modulelogo$Param pageParam) { $QueryPageSqlParameter$ return DbHelperSQL.RunProcedure("$GetPageListProcName$", parameters, "pagetable"); } #endregion #region QueryList /// /// »ñµÃ$ChinaComment$Êý¾ÝÁбí /// /// ²éѯÌõ¼þ /// $ChinaComment$ÁбíDataSet 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) /// /// µÃµ½Ò»¸ö$ChinaComment$ʵÌå /// /// $PrimaryKeyDesc$ /// $ChinaComment$ʵÌå 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 /// /// ÊÇ·ñ´æÔÚ¸Ã$ChinaComment$¼Ç¼ /// /// $PrimaryKeyDesc$ /// ÊÇ·ñ´æÔÚ¸Ã$ChinaComment$¼Ç¼ 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 } }