public static int UpdateTestRepairItem(mg_TestRepairItemModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update mg_Test_Repair_Item set "); strSql.Append("ItemCaption=@ItemCaption,"); strSql.Append("ItemType=@ItemType,"); strSql.Append("Sorting=@Sorting,"); strSql.Append("IsUseing=@IsUseing"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@ItemCaption", SqlDbType.NVarChar), new SqlParameter("@ItemType", SqlDbType.Int), new SqlParameter("@Sorting", SqlDbType.Int), new SqlParameter("@IsUseing", SqlDbType.Int), }; parameters[0].Value = model.tr_id; parameters[1].Value = model.ItemCaption; parameters[2].Value = model.ItemType; parameters[3].Value = model.Sorting; parameters[4].Value = model.IsUseing; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters); return(rows); }
public static List <mg_TestRepairItemModel> QueryListForPaging(string page, string pagesize, out string total) { total = "0"; List <mg_TestRepairItemModel> list = null; string sql1 = @"select count(ID) total from [mg_Test_Repair_Item];"; string sql2 = @" SELECT top " + pagesize + @" ID trid ,ItemCaption ,ItemType ,case ItemType when 1 then '前排' when 2 then'后排靠背' when 3 then'后排坐垫' end as ItemTypeName ,Sorting ,IsUseing ,case IsUseing when 1 then '在用' when 0 then '停用' end as IsUseingName FROM [mg_Test_Repair_Item] where ID not in ( select top ((" + page + @"-1)*" + pagesize + @") ID from [mg_Test_Repair_Item] order by ID) order by ID "; DataSet ds = SqlHelper.GetDataSetTableMapping(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql1 + sql2, new string[] { "count", "data" }, null); if (DataHelper.HasData(ds)) { DataTable dt1 = ds.Tables["count"]; total = DataHelper.GetCellDataToStr(dt1.Rows[0], "total"); DataTable dt2 = ds.Tables["data"]; list = new List <mg_TestRepairItemModel>(); foreach (DataRow row in dt2.Rows) { mg_TestRepairItemModel model = new mg_TestRepairItemModel(); model.tr_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "trid")); model.ItemCaption = DataHelper.GetCellDataToStr(row, "ItemCaption"); model.Sorting = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "Sorting")); model.IsUseingName = DataHelper.GetCellDataToStr(row, "IsUseingName"); model.IsUseing = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "IsUseing")); model.ItemType = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "ItemType")); model.ItemTypeName = DataHelper.GetCellDataToStr(row, "ItemTypeName"); list.Add(model); } } return(list); }
void saveTestRepairItem() { string tr_id = Request.Params["tr_id"]; string ItemCaption = Request.Params["ItemCaption"]; string ItemType = Request.Params["ItemType"]; string Sorting = Request.Params["Sorting"]; string IsUseing = Request.Params["IsUseing"]; mg_TestRepairItemModel model = new mg_TestRepairItemModel(); model.tr_id = NumericParse.StringToInt(tr_id); model.ItemCaption = ItemCaption; model.ItemType = NumericParse.StringToInt(ItemType); model.Sorting = NumericParse.StringToInt(Sorting);; model.IsUseing = NumericParse.StringToInt(IsUseing); string json = mg_TestRepairItemBLL.saveTestRepairItem(model); Response.Write(json); Response.End(); }
public static int AddTestRepairItem(mg_TestRepairItemModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into mg_Test_Repair_Item("); strSql.Append("ItemCaption,ItemType,Sorting,IsUseing)"); strSql.Append(" values ("); strSql.Append("@ItemCaption,@ItemType,@Sorting,@IsUseing)"); SqlParameter[] parameters = { new SqlParameter("@ItemCaption", SqlDbType.NVarChar), new SqlParameter("@ItemType", SqlDbType.Int), new SqlParameter("@Sorting", SqlDbType.Int), new SqlParameter("@IsUseing", SqlDbType.Int) }; parameters[0].Value = model.ItemCaption; parameters[1].Value = model.ItemType; parameters[2].Value = model.Sorting; parameters[3].Value = model.IsUseing; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters); return(rows); }
private static string UpdateTestRepairItem(mg_TestRepairItemModel model) { int count = mg_TestRepairItemDAL.UpdateTestRepairItem(model); return(count > 0 ? "true" : "false"); }
public static string saveTestRepairItem(mg_TestRepairItemModel model) { return(model.tr_id == 0 ? AddTestRepairItem(model) : UpdateTestRepairItem(model)); }