void AddBody(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkBodyEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into MIKANX(");
strSql.Append("ANX001,ANX002,ANX003,ANX004,ANX005,ANX006,ANX007,ANX008,ANX009,ANX010,ANX011,ANX012,ANX013,ANX014,ANX015,ANX016,ANX017,ANX018)");
strSql.Append(" values (");
strSql.Append("@ANX001,@ANX002,@ANX003,@ANX004,@ANX005,@ANX006,@ANX007,@ANX008,@ANX009,@ANX010,@ANX011,@ANX012,@ANX013,@ANX014,@ANX015,@ANX016,@ANX017,@ANX018)");
SqlParameter [] parameters =
{
new SqlParameter("@ANX001", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX004", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX005", SqlDbType.DateTime),
new SqlParameter("@ANX006", SqlDbType.DateTime),
new SqlParameter("@ANX007", SqlDbType.DateTime),
new SqlParameter("@ANX008", SqlDbType.DateTime),
new SqlParameter("@ANX009", SqlDbType.Decimal, 9),
new SqlParameter("@ANX010", SqlDbType.Decimal, 9),
new SqlParameter("@ANX011", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX012", SqlDbType.NVarChar, 100),
new SqlParameter("@ANX013", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX014", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX015", SqlDbType.Decimal, 9),
new SqlParameter("@ANX016", SqlDbType.Decimal, 9),
new SqlParameter("@ANX017", SqlDbType.Decimal, 9),
new SqlParameter("@ANX018", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.ANX001;
parameters [1].Value = model.ANX002;
parameters [2].Value = model.ANX003;
parameters [3].Value = model.ANX004;
parameters [4].Value = model.ANX005;
parameters [5].Value = model.ANX006;
parameters [6].Value = model.ANX007;
parameters [7].Value = model.ANX008;
parameters [8].Value = model.ANX009;
parameters [9].Value = model.ANX010;
parameters [10].Value = model.ANX011;
parameters [11].Value = model.ANX012;
parameters [12].Value = model.ANX013;
parameters [13].Value = model.ANX014;
parameters [14].Value = model.ANX015;
parameters [15].Value = model.ANX016;
parameters [16].Value = model.ANX017;
parameters [17].Value = model.ANX018;
SQLString.Add(strSql, parameters);
}
void EditBody(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkBodyEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update MIKANX set ");
strSql.Append("ANX002=@ANX002,");
strSql.Append("ANX003=@ANX003,");
strSql.Append("ANX004=@ANX004,");
strSql.Append("ANX005=@ANX005,");
strSql.Append("ANX006=@ANX006,");
strSql.Append("ANX007=@ANX007,");
strSql.Append("ANX008=@ANX008,");
strSql.Append("ANX009=@ANX009,");
strSql.Append("ANX010=@ANX010,");
strSql.Append("ANX011=@ANX011,");
strSql.Append("ANX012=@ANX012,");
strSql.Append("ANX013=@ANX013,");
strSql.Append("ANX014=@ANX014,");
strSql.Append("ANX015=@ANX015,");
strSql.Append("ANX016=@ANX016,");
strSql.Append("ANX017=@ANX017,");
strSql.Append("ANX018=@ANX018 ");
strSql.Append(" WHERE idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@ANX003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX004", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX005", SqlDbType.DateTime),
new SqlParameter("@ANX006", SqlDbType.DateTime),
new SqlParameter("@ANX007", SqlDbType.DateTime),
new SqlParameter("@ANX008", SqlDbType.DateTime),
new SqlParameter("@ANX009", SqlDbType.Decimal, 9),
new SqlParameter("@ANX010", SqlDbType.Decimal, 9),
new SqlParameter("@ANX011", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX012", SqlDbType.NVarChar, 100),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@ANX002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX013", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX014", SqlDbType.NVarChar, 20),
new SqlParameter("@ANX015", SqlDbType.Decimal, 9),
new SqlParameter("@ANX016", SqlDbType.Decimal, 9),
new SqlParameter("@ANX017", SqlDbType.Decimal, 9),
new SqlParameter("@ANX018", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.ANX003;
parameters [1].Value = model.ANX004;
parameters [2].Value = model.ANX005;
parameters [3].Value = model.ANX006;
parameters [4].Value = model.ANX007;
parameters [5].Value = model.ANX008;
parameters [6].Value = model.ANX009;
parameters [7].Value = model.ANX010;
parameters [8].Value = model.ANX011;
parameters [9].Value = model.ANX012;
parameters [10].Value = model.idx;
parameters [11].Value = model.ANX002;
parameters [12].Value = model.ANX013;
parameters [13].Value = model.ANX014;
parameters [14].Value = model.ANX015;
parameters [15].Value = model.ANX016;
parameters [16].Value = model.ANX017;
parameters [17].Value = model.ANX018;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_header"></param>
/// <param name="tableView"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.AssNewWorkHeaderEntity _header, DataTable tableView, List <string> idxList, DataTable tableViewTwo, List <string> idxListOne)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
//Hashtable SQLString = new Hashtable ( );
StringBuilder strSql = new StringBuilder( );
EditHeader(SQLString, strSql, _header);
LineProductMesEntityu.AssNewWorkBodyEntity model = new LineProductMesEntityu.AssNewWorkBodyEntity( );
foreach (DataRow row in tableView.Rows)
{
model.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
model.ANX001 = _header.ANW001;
model.ANX002 = row ["ANX002"].ToString( );
model.ANX003 = row ["ANX003"].ToString( );
model.ANX004 = row ["ANX004"].ToString( );
if (string.IsNullOrEmpty(row ["ANX005"].ToString( )))
{
model.ANX005 = null;
}
else
{
model.ANX005 = Convert.ToDateTime(row ["ANX005"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX006"].ToString( )))
{
model.ANX006 = null;
}
else
{
model.ANX006 = Convert.ToDateTime(row ["ANX006"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX007"].ToString( )))
{
model.ANX007 = null;
}
else
{
model.ANX007 = Convert.ToDateTime(row ["ANX007"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX008"].ToString( )))
{
model.ANX008 = null;
}
else
{
model.ANX008 = Convert.ToDateTime(row ["ANX008"].ToString( ));
}
model.ANX009 = string.IsNullOrEmpty(row ["ANX009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX009"].ToString( ));
model.ANX010 = string.IsNullOrEmpty(row ["ANX010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX010"].ToString( ));
model.ANX011 = row ["ANX011"].ToString( );
model.ANX012 = row ["ANX012"].ToString( );
model.ANX013 = row ["ANX013"].ToString( );
model.ANX014 = row ["ANX014"].ToString( );
model.ANX015 = string.IsNullOrEmpty(row ["ANX015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX015"].ToString( ));
model.ANX016 = string.IsNullOrEmpty(row ["ANX016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX016"].ToString( ));
model.ANX017 = string.IsNullOrEmpty(row ["ANX017"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX017"].ToString( ));
if (string.IsNullOrEmpty(row ["ANX018"].ToString( )))
{
model.ANX018 = null;
}
else
{
model.ANX018 = Convert.ToDecimal(row ["ANX018"].ToString( ));
}
if (!string.IsNullOrEmpty(model.ANX002))
{
if (model.idx > 0)
{
EditBody(SQLString, strSql, model);
}
else
{
AddBody(SQLString, strSql, model);
}
}
}
LineProductMesEntityu.AssNewWorkBodyAnnEntity bodyOne = new LineProductMesEntityu.AssNewWorkBodyAnnEntity( );
bodyOne.ANN001 = _header.ANW001;
foreach (DataRow row in tableViewTwo.Rows)
{
bodyOne.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]);
bodyOne.ANN002 = row ["ANN002"].ToString( );
bodyOne.ANN003 = row ["ANN003"].ToString( );
bodyOne.ANN004 = row ["ANN004"].ToString( );
bodyOne.ANN005 = row ["ANN005"].ToString( );
bodyOne.ANN006 = row ["ANN006"].ToString( );
bodyOne.ANN007 = string.IsNullOrEmpty(row ["ANN007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN007"]);
bodyOne.ANN008 = string.IsNullOrEmpty(row ["ANN008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANN008"]);
bodyOne.ANN009 = string.IsNullOrEmpty(row ["ANN009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN009"]);
bodyOne.ANN010 = row ["ANN010"].ToString( );
if (!string.IsNullOrEmpty(bodyOne.ANN002))
{
if (bodyOne.idx > 0)
{
EditBodyOne(SQLString, strSql, bodyOne);
}
else
{
AddBodyOne(SQLString, strSql, bodyOne);
}
}
}
foreach (string s in idxList)
{
if (Convert.ToInt32(s) > 0)
{
DeleteBody(SQLString, strSql, s);
}
}
foreach (string s in idxListOne)
{
if (Convert.ToInt32(s) > 0)
{
DeleteBodyOne(SQLString, strSql, s);
}
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="_header"></param>
/// <param name="tableView"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.AssNewWorkHeaderEntity _header, DataTable tableView, DataTable tableViewTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
//Hashtable SQLString = new Hashtable ( );
StringBuilder strSql = new StringBuilder( );
_header.ANW001 = getOddNum( );
_header.ANW025 = UserInfoMation.userName;
AddHeader(SQLString, strSql, _header);
UserInfoMation.oddNum = _header.ANW001;
LineProductMesEntityu.AssNewWorkBodyEntity model = new LineProductMesEntityu.AssNewWorkBodyEntity( );
foreach (DataRow row in tableView.Rows)
{
model.ANX001 = _header.ANW001;
model.ANX002 = row ["ANX002"].ToString( );
model.ANX003 = row ["ANX003"].ToString( );
model.ANX004 = row ["ANX004"].ToString( );
if (string.IsNullOrEmpty(row ["ANX005"].ToString( )))
{
model.ANX005 = null;
}
else
{
model.ANX005 = Convert.ToDateTime(row ["ANX005"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX006"].ToString( )))
{
model.ANX006 = null;
}
else
{
model.ANX006 = Convert.ToDateTime(row ["ANX006"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX007"].ToString( )))
{
model.ANX007 = null;
}
else
{
model.ANX007 = Convert.ToDateTime(row ["ANX007"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX008"].ToString( )))
{
model.ANX008 = null;
}
else
{
model.ANX008 = Convert.ToDateTime(row ["ANX008"].ToString( ));
}
model.ANX009 = string.IsNullOrEmpty(row ["ANX009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX009"].ToString( ));
model.ANX010 = string.IsNullOrEmpty(row ["ANX010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX010"].ToString( ));
model.ANX011 = row ["ANX011"].ToString( );
model.ANX012 = row ["ANX012"].ToString( );
model.ANX013 = row ["ANX013"].ToString( );
model.ANX014 = row ["ANX014"].ToString( );
model.ANX015 = string.IsNullOrEmpty(row ["ANX015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX015"].ToString( ));
model.ANX016 = string.IsNullOrEmpty(row ["ANX016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX016"].ToString( ));
model.ANX017 = string.IsNullOrEmpty(row ["ANX017"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX017"].ToString( ));
if (string.IsNullOrEmpty(row ["ANX018"].ToString( )))
{
model.ANX018 = null;
}
else
{
model.ANX018 = Convert.ToDecimal(row ["ANX018"].ToString( ));
}
if (!string.IsNullOrEmpty(model.ANX002))
{
AddBody(SQLString, strSql, model);
}
}
LineProductMesEntityu.AssNewWorkBodyAnnEntity bodyOne = new LineProductMesEntityu.AssNewWorkBodyAnnEntity( );
bodyOne.ANN001 = _header.ANW001;
foreach (DataRow row in tableViewTwo.Rows)
{
bodyOne.ANN002 = row ["ANN002"].ToString( );
bodyOne.ANN003 = row ["ANN003"].ToString( );
bodyOne.ANN004 = row ["ANN004"].ToString( );
bodyOne.ANN005 = row ["ANN005"].ToString( );
bodyOne.ANN006 = row ["ANN006"].ToString( );
bodyOne.ANN007 = string.IsNullOrEmpty(row ["ANN007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN007"]);
bodyOne.ANN008 = string.IsNullOrEmpty(row ["ANN008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANN008"]);
bodyOne.ANN009 = string.IsNullOrEmpty(row ["ANN009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN009"]);
bodyOne.ANN010 = row ["ANN010"].ToString( );
if (!string.IsNullOrEmpty(bodyOne.ANN002))
{
AddBodyOne(SQLString, strSql, bodyOne);
}
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
