void SaveStep() { string step_id = Request.Params["step_id"]; string fl_id = Request.Params["fl_id"]; string st_id = Request.Params["st_id"]; string bom_id = Request.Params["bom_id"]; string part_id = Request.Params["part_id"]; string step_name = Request.Params["step_name"]; string step_clock = Request.Params["step_clock"]; string step_plccode = Request.Params["step_plccode"]; string barcode_start = Request.Params["barcode_start"]; string barcode_number = Request.Params["barcode_number"]; string bom_count = Request.Params["bom_count"]; string step_pic = Request.Params["step_pic"]; string step_desc = Request.Params["step_desc"]; //string odsName = Request.Params["odsName"]; //string odsKeyword = Request.Params["odsKeyword"]; mg_StepModel model = new mg_StepModel(); model.step_id = NumericParse.StringToInt(step_id); model.fl_id = NumericParse.StringToInt(fl_id); model.st_id = NumericParse.StringToInt(st_id); model.bom_id = NumericParse.StringToInt(bom_id); model.part_id = NumericParse.StringToInt(part_id); model.step_name = step_name; model.step_clock = NumericParse.StringToInt(step_clock); model.step_plccode = NumericParse.StringToInt(step_plccode); model.barcode_start = NumericParse.StringToInt(barcode_start); model.barcode_number = NumericParse.StringToInt(barcode_number); model.bom_count = NumericParse.StringToInt(bom_count); model.step_pic = step_pic; model.step_desc = step_desc; //model.odsName = odsName; //model.odsKeyword = odsKeyword; //string json = mg_StepBLL.saveStepAndODS(model); string json = mg_StepBLL.saveStep(model); Response.Write(json); Response.End(); }
private static string UpdateStepAndODS(mg_StepModel model) { int count = mg_StepDAL.UpdateStepAndODS(model); return(count > 0 ? "true" : "false"); }
private static string AddStep(mg_StepModel model) { int count = mg_StepDAL.AddStep(model); return(count > 0 ? "true" : "false"); }
public static string saveStep(mg_StepModel model) { return(model.step_id == 0 ? AddStep(model) : UpdateStep(model)); }
public static List <mg_StepModel> QueryListForFirstPage(string currentpage, string pagesize, out string total, string fl_id, string st_id, string part_id) { total = "0"; List <mg_StepModel> list = null; string queryStr = (!string.IsNullOrEmpty(fl_id) && fl_id != "0") ? " where st.fl_id=" + fl_id : " where step.step_id is not null "; queryStr += (!string.IsNullOrEmpty(st_id) && st_id != "0") ? " and step.st_id=" + st_id : " "; queryStr += (!string.IsNullOrEmpty(part_id) && part_id != "0") ? " and step.part_id=" + part_id : " "; string sql1 = @"select count(step_id) total from [mg_step] step left join mg_station st on step.st_id = st.st_id " + queryStr + @" ;"; string sql2 = @" select top " + pagesize + @" A.* from ( select ROW_NUMBER() over(order by step.step_order) as rowid , [step_id] ,[step_name] ,st.[fl_id] ,fl.fl_name ,step.[st_id] ,st.st_name ,step.[bom_id] ,b.bom_PN ,step.[part_id] ,p.part_no ,p.part_name ,b.bom_desc ,[bom_count] ,[step_clock] ,[step_desc] ,[step_pic] ,[step_plccode] ,[step_order] ,b.[barcode_start] ,b.[barcode_number] FROM [mg_step] step left join mg_station st on step.st_id = st.st_id left join mg_FlowLine fl on st.fl_id = fl.fl_id left join mg_BOM b on step.bom_id=b.bom_id left join mg_part p on step.part_id=p.part_id " + queryStr + @") as A where rowid> (" + pagesize + ")*((" + currentpage + ")-1)"; 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_StepModel>(); foreach (DataRow row in dt2.Rows) { mg_StepModel model = new mg_StepModel(); model.step_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "step_id")); model.step_name = DataHelper.GetCellDataToStr(row, "step_name"); model.fl_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "fl_id")); model.fl_name = DataHelper.GetCellDataToStr(row, "fl_name"); model.st_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "st_id")); model.st_name = DataHelper.GetCellDataToStr(row, "st_name"); model.bom_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "bom_id")); model.bom_PN = DataHelper.GetCellDataToStr(row, "bom_PN") + " | " + DataHelper.GetCellDataToStr(row, "bom_desc"); model.bom_desc = DataHelper.GetCellDataToStr(row, "bom_desc"); model.bom_count = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "bom_count")); model.step_clock = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "step_clock")); model.step_desc = DataHelper.GetCellDataToStr(row, "step_desc"); model.step_pic = DataHelper.GetCellDataToStr(row, "step_pic"); model.step_plccode = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "step_plccode")); model.step_order = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "step_order")); model.barcode_start = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "barcode_start")); model.barcode_number = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "barcode_number")); model.part_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "part_id")); model.part_no = DataHelper.GetCellDataToStr(row, "part_no") + " | " + DataHelper.GetCellDataToStr(row, "part_name"); list.Add(model); } } return(list); }
public static int AddStep(mg_StepModel model) { string maxid = @"declare @i int;declare @o int; SELECT @i=max([step_id]) FROM [mg_step]; if @i is null begin set @i=1 end else begin set @i=@i+1 end; SELECT @o=max([step_order]) FROM [mg_step]; if @o is null begin set @o=1 end else begin set @o=@o+1 end; "; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into mg_step("); strSql.Append("step_id,step_name,st_id,bom_id,bom_count,step_clock,step_desc,step_pic,step_plccode,step_order,part_id,barcode_start,barcode_number)"); strSql.Append(" values ("); strSql.Append("@i,@step_name,@st_id,@bom_id,@bom_count,@step_clock,@step_desc,@step_pic,@step_plccode,@o,@part_id,@barcode_start,@barcode_number)"); SqlParameter[] parameters = { new SqlParameter("@step_name", SqlDbType.NVarChar), //new SqlParameter("@fl_id", SqlDbType.Int), new SqlParameter("@st_id", SqlDbType.Int), new SqlParameter("@bom_id", SqlDbType.Int), new SqlParameter("@bom_count", SqlDbType.Int), new SqlParameter("@step_clock", SqlDbType.Int), new SqlParameter("@step_desc", SqlDbType.NVarChar), new SqlParameter("@step_pic", SqlDbType.NVarChar), new SqlParameter("@step_plccode", SqlDbType.Int), new SqlParameter("@barcode_start", SqlDbType.Int), new SqlParameter("@barcode_number", SqlDbType.Int), new SqlParameter("@part_id", SqlDbType.Int) }; parameters[0].Value = model.step_name; //parameters[1].Value = model.fl_id; parameters[1].Value = model.st_id; parameters[2].Value = model.bom_id; parameters[3].Value = model.bom_count; parameters[4].Value = model.step_clock; parameters[5].Value = model.step_desc; parameters[6].Value = model.step_pic; parameters[7].Value = model.step_plccode; parameters[8].Value = model.barcode_start; parameters[9].Value = model.barcode_number; parameters[10].Value = model.part_id; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, maxid + strSql, parameters); return(rows); }
/* * * 姜任鹏 * */ public static int AddStepAndODS(mg_StepModel model) { string maxid = @"declare @i int;declare @o int; SELECT @i=max([step_id]) FROM [mg_step]; if @i is null begin set @i=1 end else begin set @i=@i+1 end; SELECT @o=max([step_order]) FROM [mg_step]; if @o is null begin set @o=1 end else begin set @o=@o+1 end; "; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into mg_step("); strSql.Append("step_id,step_name,st_id,bom_id,bom_count,step_clock,step_desc,step_pic,step_plccode,step_order,part_id)"); strSql.Append(" values ("); strSql.Append("@i,@step_name,@st_id,@bom_id,@bom_count,@step_clock,@step_desc,@step_pic,@step_plccode,@o,@part_id);"); SqlParameter[] parameters = { new SqlParameter("@step_name", SqlDbType.NVarChar), //new SqlParameter("@fl_id", SqlDbType.Int), new SqlParameter("@st_id", SqlDbType.Int), new SqlParameter("@bom_id", SqlDbType.Int), new SqlParameter("@bom_count", SqlDbType.Int), new SqlParameter("@step_clock", SqlDbType.Int), new SqlParameter("@step_desc", SqlDbType.NVarChar), new SqlParameter("@step_pic", SqlDbType.NVarChar), new SqlParameter("@step_plccode", SqlDbType.Int), new SqlParameter("@part_id", SqlDbType.Int) }; parameters[0].Value = model.step_name; // parameters[1].Value = model.fl_id; parameters[1].Value = model.st_id; parameters[2].Value = model.bom_id; parameters[3].Value = model.bom_count; parameters[4].Value = model.step_clock; parameters[5].Value = model.step_desc; parameters[6].Value = model.step_pic; parameters[7].Value = model.step_plccode; parameters[8].Value = model.part_id; if (!string.IsNullOrEmpty(model.odsName)) { string[] odsnameArr = model.odsName.Split('|'); string[] odskeyArr = model.odsKeyword.Split('|'); string odsStr = @"INSERT INTO [mg_ODS] ([ods_id] ,[step_id] ,[ods_name] ,[ods_keywords]) VALUES ($ods_id$ ,$step_id$ ,'$ods_name$' ,'$ods_keywords$');"; for (int i = 0; i < odsnameArr.Length; i++) { string key = ""; if ((i + 1) <= odskeyArr.Length) { key = odskeyArr[i]; } strSql.Append(odsStr.Replace("$ods_id$", (i + 1).ToString()).Replace("$step_id$", "@i").Replace("$ods_name$", odsnameArr[i]).Replace("$ods_keywords$", key)); } } int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, maxid + strSql, parameters); return(rows); }