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);
}
