void SavePart1() { string part_id = Request.Params["part_id"]; string part_no = Request.Params["part_no"]; string part_name = Request.Params["part_name"]; string part_categoryid = Request.Params["part_categoryid"]; string part_desc = Request.Params["part_desc"]; string part_type = Request.Params["part_type"]; string FlowLine = Request.Params["FlowLine"]; string Product = Request.Params["Product"]; mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(part_id); model.part_no = part_no; model.part_name = part_name; model.part_categoryid = NumericParse.StringToInt(part_categoryid); model.part_desc = part_desc; model.part_type = NumericParse.StringToInt(part_type); model.pflowlineid = NumericParse.StringToInt(FlowLine); model.pproductid = NumericParse.StringToInt(Product); string json = mg_Part1BLL.SavePart1(model); Response.Write(json); Response.End(); }
public static List <mg_partModel> QueryPartForPartidList() { List <mg_partModel> list = null; string sql2 = @" SELECT [part_id] ,[part_name] FROM [mg_part] "; DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null); if (DataHelper.HasData(dt)) { list = new List <mg_partModel>(); foreach (DataRow row in dt.Rows) { mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_id")); model.part_name = DataHelper.GetCellDataToStr(row, "part_name"); list.Add(model); } } return(list); }
public static List <mg_partModel> QueryListForPaging(string page, string pagesize, out string total) { total = "0"; List <mg_partModel> list = null; string sql1 = @"select count(part_id) total from [mg_part];"; string sql2 = @" with data as ( select allp.all_id,allp.all_no,aprel.partid_id from [mg_allpart_part_rel] aprel left join [mg_allpart] allp on aprel.all_id=allp.all_id ) SELECT top " + pagesize + @" [part_id] ,[part_no] ,[part_name] ,[part_desc] ,[part_categoryid] ,prop.prop_name [part_Category] ,STUFF((SELECT ','+cast (all_id as varchar) from data allp where allp.partid_id=p.part_id for xml path('')),1,1,'')allpartIDs ,STUFF((SELECT ','+cast (all_no as varchar) from data allp where allp.partid_id=p.part_id for xml path('')),1,1,'')allpartNOs FROM [mg_part] p left join mg_Property prop on p.part_categoryid = prop.prop_id where p.part_id < ( select top 1 part_id from (select top ((" + page + @"-1)*" + pagesize + @") part_id from [mg_part] where part_id is not null order by part_id desc )t order by part_id ) order by part_id desc "; 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_partModel>(); foreach (DataRow row in dt2.Rows) { mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_id")); model.part_no = DataHelper.GetCellDataToStr(row, "part_no"); model.part_name = DataHelper.GetCellDataToStr(row, "part_name"); model.part_desc = DataHelper.GetCellDataToStr(row, "part_desc"); model.part_categoryid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_categoryid")); model.part_Category = DataHelper.GetCellDataToStr(row, "part_Category"); model.allpartIDs = DataHelper.GetCellDataToStr(row, "allpartIDs"); model.allpartNOs = DataHelper.GetCellDataToStr(row, "allpartNOs"); list.Add(model); } } return(list); }
public static bool AddPart(mg_partModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"declare @i int; SELECT @i=max([part_id]) FROM [mg_part]; if @i is null begin set @i=1 end else begin set @i=@i+1 end; "); strSql.Append("insert into mg_part("); strSql.Append("part_id,part_no,part_name,part_desc,part_categoryid)"); strSql.Append(" values ("); strSql.Append("@i,@part_no,@part_name,@part_desc,@part_categoryid);"); SqlParameter[] parameters = { new SqlParameter("@part_id", SqlDbType.Int), new SqlParameter("@part_no", SqlDbType.NVarChar), new SqlParameter("@part_name", SqlDbType.NVarChar), new SqlParameter("@part_desc", SqlDbType.NVarChar), new SqlParameter("@part_categoryid", SqlDbType.Int) }; parameters[0].Value = model.part_id; parameters[1].Value = model.part_no; parameters[2].Value = model.part_name; parameters[3].Value = model.part_desc; parameters[4].Value = model.part_categoryid; if (!string.IsNullOrEmpty(model.allpartIDs)) { string[] idArr = model.allpartIDs.Split(','); foreach (string id in idArr) { strSql.Append("INSERT INTO [mg_allpart_part_rel] ([all_id],[partid_id]) VALUES (" + id + ",@i);"); } } List <SqlParameter> list = new List <SqlParameter>(); list.AddRange(parameters); return(SqlHelper.ExecuteSqlTran(SqlHelper.SqlConnString, strSql.ToString(), list)); }
public static List <mg_partModel> QueryPartListForBOM() { List <mg_partModel> list = null; string sql2 = @" with data as ( select allp.all_id,allp.all_no,aprel.partid_id from [mg_allpart_part_rel] aprel left join [mg_allpart] allp on aprel.all_id=allp.all_id ) SELECT [part_id] ,[part_no] ,[part_name] ,[part_desc] ,[part_categoryid] ,prop.prop_name [part_Category] ,STUFF((SELECT ','+cast (all_id as varchar) from data allp where allp.partid_id=p.part_id for xml path('')),1,1,'')allpartIDs ,STUFF((SELECT ','+cast (all_no as varchar) from data allp where allp.partid_id=p.part_id for xml path('')),1,1,'')allpartNOs FROM [mg_part] p left join mg_Property prop on p.part_categoryid = prop.prop_id order by part_no "; DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null); if (DataHelper.HasData(dt)) { list = new List <mg_partModel>(); foreach (DataRow row in dt.Rows) { mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_id")); model.part_no = DataHelper.GetCellDataToStr(row, "part_no"); model.part_name = DataHelper.GetCellDataToStr(row, "part_name"); model.part_desc = DataHelper.GetCellDataToStr(row, "part_desc"); model.part_categoryid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_categoryid")); model.part_Category = DataHelper.GetCellDataToStr(row, "part_Category"); model.allpartIDs = DataHelper.GetCellDataToStr(row, "allpartIDs"); model.allpartNOs = DataHelper.GetCellDataToStr(row, "allpartNOs"); list.Add(model); } } return(list); }
public static int AddPart1(mg_partModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"declare @i int; SELECT @i=max([part_id]) FROM [mg_part]; if @i is null begin set @i=1 end else begin set @i=@i+1 end; "); strSql.Append("insert into mg_part("); strSql.Append("part_id,part_no,part_name,part_desc,part_categoryid,PartType,FlowLineID,ProductID)"); strSql.Append(" values ("); strSql.Append("@i,@part_no,@part_name,@part_desc,@part_categoryid,@PartType,@FlowLineID,@ProductID)"); SqlParameter[] parameters = { new SqlParameter("@part_id", SqlDbType.Int), new SqlParameter("@part_no", SqlDbType.NVarChar), new SqlParameter("@part_name", SqlDbType.NVarChar), new SqlParameter("@part_desc", SqlDbType.NVarChar), new SqlParameter("@part_categoryid", SqlDbType.Int), new SqlParameter("@PartType", SqlDbType.Int), new SqlParameter("@FlowLineID", SqlDbType.Int), new SqlParameter("@ProductID", SqlDbType.Int) }; parameters[0].Value = model.part_id; parameters[1].Value = model.part_no; parameters[2].Value = model.part_name; parameters[3].Value = model.part_desc; parameters[4].Value = model.part_categoryid; parameters[5].Value = model.part_type; parameters[6].Value = model.pflowlineid; parameters[7].Value = model.pproductid; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters); return(rows); }
public static int UpdatePart1(mg_partModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update mg_part set "); strSql.Append("part_no=@part_no,"); strSql.Append("part_name=@part_name,"); strSql.Append("part_desc=@part_desc,"); strSql.Append("part_categoryid=@part_categoryid,"); strSql.Append("PartType=@PartType,"); strSql.Append("FlowLineID=@FlowLineID,"); strSql.Append("ProductID=@ProductID"); strSql.Append(" where part_id=@part_id"); SqlParameter[] parameters = { new SqlParameter("@part_id", SqlDbType.Int), new SqlParameter("@part_no", SqlDbType.NVarChar), new SqlParameter("@part_name", SqlDbType.NVarChar), new SqlParameter("@part_desc", SqlDbType.NVarChar), new SqlParameter("@part_categoryid", SqlDbType.Int), new SqlParameter("@PartType", SqlDbType.Int), new SqlParameter("@FlowLineID", SqlDbType.Int), new SqlParameter("@ProductID", SqlDbType.Int) }; parameters[0].Value = model.part_id; parameters[1].Value = model.part_no; parameters[2].Value = model.part_name; parameters[3].Value = model.part_desc; parameters[4].Value = model.part_categoryid; parameters[5].Value = model.part_type; parameters[6].Value = model.pflowlineid; parameters[7].Value = model.pproductid; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters); return(rows); }
public static List <mg_partModel> queryPartForStepSearching() { List <mg_partModel> list = null; string sql2 = @" SELECT [part_id] ,[part_no] ,[part_name] ,[part_desc] ,[part_categoryid] FROM [mg_part] p order by part_no "; DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null); if (DataHelper.HasData(dt)) { list = new List <mg_partModel>(); foreach (DataRow row in dt.Rows) { mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_id")); model.part_no = DataHelper.GetCellDataToStr(row, "part_no") + " | " + DataHelper.GetCellDataToStr(row, "part_name"); model.part_name = DataHelper.GetCellDataToStr(row, "part_name"); model.part_desc = DataHelper.GetCellDataToStr(row, "part_desc"); list.Add(model); } mg_partModel firstmodel = new mg_partModel(); firstmodel.part_id = 0; firstmodel.part_no = "-- 部件(全部) --"; list.Insert(0, firstmodel); } return(list); }
void savePart() { string part_id = Request.Params["part_id"]; string part_categoryid = Request.Params["part_categoryid"]; string part_no = Request.Params["part_no"]; string part_desc = Request.Params["part_desc"]; string part_name = Request.Params["part_name"]; string allpartIDs = Request.Params["allpartIDs"]; mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(part_id); model.part_categoryid = NumericParse.StringToInt(part_categoryid); model.part_no = (!string.IsNullOrEmpty(part_no)) ? part_no.Trim() : ""; model.part_desc = part_desc; model.part_name = part_name; model.allpartIDs = allpartIDs; string json = mg_PartBLL.SavePart(model); Response.Write(json); Response.End(); }
private static string AddPart(mg_partModel model) { bool flag = mg_PartDAL.AddPart(model); return(flag ? "true" : "false"); }
/* * * 姜任鹏 * */ public static string SavePart(mg_partModel model) { return(model.part_id == 0 ? AddPart(model) : UpdatePart(model)); }
public static List <mg_partModel> QueryListForPaging(string page, string pagesize, out string total) { total = "0"; List <mg_partModel> list = null; string sql1 = @"select count(part_id) total from [mg_part];"; string sql2 = @"SELECT top " + pagesize + @" a.part_id pid ,a.part_no part_no ,a.part_name part_name ,a.part_desc part_desc ,a.PartType ,case a.PartType when 1 then '主驾靠背' when 2 then '主驾坐垫' when 3 then '主驾总' when 4 then '副驾靠背' when 5 then '副驾坐垫' when 6 then '副驾总' when 7 then '后排40%' when 8 then '后排60%' when 9 then '后排100%' end as PartTypeName ,b.prop_id Propid ,b.prop_name PropName ,c.fl_id ,c.fl_name fl_name ,d.ID ProductID ,d.ProductName ProductName FROM [mg_part] a left join mg_Property b on a.part_categoryid = b.prop_id left join mg_FlowLine c on a.FlowLineID = c.fl_id left join mg_Product d on a.ProductID = d.ID where d.IsUseing=1 and a.part_id not in (select top ((" + page + @"-1)*" + pagesize + @") part_id from [mg_part] order by part_id desc) order by a.part_id desc "; 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_partModel>(); foreach (DataRow row in dt2.Rows) { mg_partModel model = new mg_partModel(); model.part_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "pid")); model.part_no = DataHelper.GetCellDataToStr(row, "part_no"); model.part_name = DataHelper.GetCellDataToStr(row, "part_name"); model.part_desc = DataHelper.GetCellDataToStr(row, "part_desc"); model.parttypename = DataHelper.GetCellDataToStr(row, "PartTypeName"); model.propname = DataHelper.GetCellDataToStr(row, "PropName"); model.pflowlinename = DataHelper.GetCellDataToStr(row, "fl_name"); model.pproductname = DataHelper.GetCellDataToStr(row, "ProductName"); model.propid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "Propid")); model.part_type = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "PartType")); model.pflowlineid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "fl_id")); model.pproductid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "ProductID")); list.Add(model); } } return(list); }
private static string UpdatePart1(mg_partModel model) { int count = mg_Part1DAL.UpdatePart1(model); return(count > 0 ? "true" : "false"); }