public static int UpdateFlowLine1(mg_FlowlingModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update mg_FlowLine set ");
strSql.Append("fl_name=@fl_name,");
strSql.Append("FlowFlag=@flowflag,");
strSql.Append("FlowLineType=@FlowLineType");
strSql.Append(" where fl_id=@fl_id");
SqlParameter[] parameters =
{
new SqlParameter("@fl_id", SqlDbType.Int),
new SqlParameter("@fl_name", SqlDbType.NVarChar),
new SqlParameter("@flowflag", SqlDbType.NVarChar),
new SqlParameter("@FlowLineType", SqlDbType.Int),
};
parameters[0].Value = model.fl_id;
parameters[1].Value = model.fl_name;
parameters[2].Value = model.flowflag;
parameters[3].Value = model.flowlinetype;
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters);
return(rows);
}
public static int AddFlowLine1(mg_FlowlingModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into mg_FlowLine(");
strSql.Append("fl_name,");
strSql.Append("FlowFlag,");
strSql.Append("FlowLineType)");
strSql.Append(" values (");
strSql.Append("@fl_name,");
strSql.Append("@FlowFlag,");
strSql.Append("@FlowLineType)");
SqlParameter[] parameters =
{
new SqlParameter("@fl_name", SqlDbType.NVarChar),
new SqlParameter("@FlowFlag", SqlDbType.NVarChar),
new SqlParameter("@FlowLineType", SqlDbType.Int),
};
parameters[0].Value = model.fl_name;
parameters[1].Value = model.flowflag;
parameters[2].Value = model.flowlinetype;
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters);
return(rows);
}
public static List <mg_FlowlingModel> QueryFlowlingForEditing()
{
List <mg_FlowlingModel> list = null;
string sql = @"SELECT [fl_id]
,[fl_name]
FROM [mg_FlowLine]
order by fl_name";
DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null);
if (DataHelper.HasData(dt))
{
list = new List <mg_FlowlingModel>();
foreach (DataRow row in dt.Rows)
{
mg_FlowlingModel model = new mg_FlowlingModel();
model.fl_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "fl_id"));
model.fl_name = DataHelper.GetCellDataToStr(row, "fl_name");
list.Add(model);
}
mg_FlowlingModel firstmodel = new mg_FlowlingModel();
firstmodel.fl_id = 0;
firstmodel.fl_name = "-- 流水线(全部) --";
list.Insert(0, firstmodel);
}
return(list);
}
void saveFlowLine1()
{
string fl_id = Request.Params["fl_id"];
string fl_name = Request.Params["fl_name"];
string flowflag = Request.Params["flowflag"];
string flowlinetype = Request.Params["flowlinetype"];
mg_FlowlingModel model = new mg_FlowlingModel();
model.fl_id = NumericParse.StringToInt(fl_id);
model.fl_name = fl_name;
model.flowflag = flowflag;
model.flowlinetype = NumericParse.StringToInt(flowlinetype);
string json = mg_FlowLine1BLL.SaveFlowLine1(model);
Response.Write(json);
Response.End();
}
public static List <mg_FlowlingModel> queryFlowLineidForPart()
{
List <mg_FlowlingModel> list = null;
string sql = @"SELECT [fl_id],[fl_name],[FlowFlag] FROM [mg_FlowLine] order by fl_name ";
DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null);
if (DataHelper.HasData(dt))
{
list = new List <mg_FlowlingModel>();
foreach (DataRow row in dt.Rows)
{
mg_FlowlingModel model = new mg_FlowlingModel();
model.fl_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "fl_id"));
model.fl_name = DataHelper.GetCellDataToStr(row, "fl_name");
model.flowflag = DataHelper.GetCellDataToStr(row, "FlowFlag");
list.Add(model);
}
}
return(list);
}
public static List <mg_FlowlingModel> QueryListForPaging(string page, string pagesize, out string total)
{
total = "0";
List <mg_FlowlingModel> list = null;
string sql1 = @"select count(fl_id) total from [mg_FlowLine];";
string sql2 = @" SELECT top " + pagesize + @" fl_id fid
,fl_name
,FlowLineType
,FlowFlag
,case FlowLineType
when 1 then '前排'
when 2 then '后排' end as FLTName
FROM [mg_FlowLine]
where fl_id not in
(select top ((" + page + @"-1)*" + pagesize + @") fl_id from [mg_FlowLine] order by fl_id desc)
order by fl_name
";
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_FlowlingModel>();
foreach (DataRow row in dt2.Rows)
{
mg_FlowlingModel model = new mg_FlowlingModel();
model.fl_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "fid"));
model.fl_name = DataHelper.GetCellDataToStr(row, "fl_name");
model.fltname = DataHelper.GetCellDataToStr(row, "FLTName");
model.flowflag = DataHelper.GetCellDataToStr(row, "FlowFlag");
model.flowlinetype = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "flowlinetype"));
list.Add(model);
}
}
return(list);
}
public static List <mg_FlowlingModel> QueryListForFirstPage(string pagesize, out string total)
{
total = "0";
List <mg_FlowlingModel> list = null;
string sql1 = @"select count(fl_id) total from [mg_FlowLine];";
string sql2 = @" SELECT top " + pagesize + @" fl_id fid
,fl_name
,FlowLineType
,FlowFlag
,FlowLineType
FROM [mg_FlowLine]
order by fl_name
";
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_FlowlingModel>();
foreach (DataRow row in dt2.Rows)
{
mg_FlowlingModel model = new mg_FlowlingModel();
model.fl_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "fid"));
model.fl_name = DataHelper.GetCellDataToStr(row, "fl_name");
model.flowlinetype = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "FlowLineType"));
List <mg_PropertyModel> Propertylist = DAL.mg_PropertyDAL.queryJSONStringByPropertyType1(DataHelper.GetCellDataToStr(row, "FlowLineType")).ToList();
model.fltname = Propertylist[0].prop_name;
model.flowflag = DataHelper.GetCellDataToStr(row, "FlowFlag");
model.flowlinetype = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "FlowLineType"));
list.Add(model);
}
}
return(list);
}
private static string UpdateFlowLine1(mg_FlowlingModel model)
{
int count = mg_FlowLine1DAL.UpdateFlowLine1(model);
return(count > 0 ? "true" : "false");
}
public static string SaveFlowLine1(mg_FlowlingModel model)
{
return(model.fl_id == 0 ? AddFlowLine1(model) : UpdateFlowLine1(model));
}
