void AddBodyOne(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkEnclosureBodyOneEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into MIKANU(");
strSql.Append("ANU001,ANU002,ANU003,ANU004,ANU005,ANU006,ANU007,ANU008,ANU009,ANU010,ANU011,ANU012)");
strSql.Append(" values (");
strSql.Append("@ANU001,@ANU002,@ANU003,@ANU004,@ANU005,@ANU006,@ANU007,@ANU008,@ANU009,@ANU010,@ANU011,@ANU012)");
SqlParameter [] parameters =
{
new SqlParameter("@ANU001", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU004", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU005", SqlDbType.NVarChar, 50),
new SqlParameter("@ANU006", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU007", SqlDbType.Decimal, 9),
new SqlParameter("@ANU008", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU009", SqlDbType.NVarChar, 50),
new SqlParameter("@ANU010", SqlDbType.Int, 4),
new SqlParameter("@ANU011", SqlDbType.Int, 4),
new SqlParameter("@ANU012", SqlDbType.NVarChar, 100)
};
parameters [0].Value = model.ANU001;
parameters [1].Value = model.ANU002;
parameters [2].Value = model.ANU003;
parameters [3].Value = model.ANU004;
parameters [4].Value = model.ANU005;
parameters [5].Value = model.ANU006;
parameters [6].Value = model.ANU007;
parameters [7].Value = model.ANU008;
parameters [8].Value = model.ANU009;
parameters [9].Value = model.ANU010;
parameters [10].Value = model.ANU011;
parameters [11].Value = model.ANU012;
SQLString.Add(strSql, parameters);
}
void EditBodyOne(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkEnclosureBodyOneEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update MIKANU set ");
strSql.Append("ANU002=@ANU002,");
strSql.Append("ANU003=@ANU003,");
strSql.Append("ANU004=@ANU004,");
strSql.Append("ANU005=@ANU005,");
strSql.Append("ANU006=@ANU006,");
strSql.Append("ANU007=@ANU007,");
strSql.Append("ANU008=@ANU008,");
strSql.Append("ANU009=@ANU009,");
strSql.Append("ANU010=@ANU010,");
strSql.Append("ANU011=@ANU011,");
strSql.Append("ANU012=@ANU012");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@ANU003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU004", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU005", SqlDbType.NVarChar, 50),
new SqlParameter("@ANU006", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU007", SqlDbType.Decimal, 9),
new SqlParameter("@ANU008", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU009", SqlDbType.NVarChar, 50),
new SqlParameter("@ANU010", SqlDbType.Int, 4),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@ANU002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANU011", SqlDbType.Int, 4),
new SqlParameter("@ANU012", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.ANU003;
parameters [1].Value = model.ANU004;
parameters [2].Value = model.ANU005;
parameters [3].Value = model.ANU006;
parameters [4].Value = model.ANU007;
parameters [5].Value = model.ANU008;
parameters [6].Value = model.ANU009;
parameters [7].Value = model.ANU010;
parameters [8].Value = model.idx;
parameters [9].Value = model.ANU002;
parameters [10].Value = model.ANU011;
parameters [11].Value = model.ANU012;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableViewOne"></param>
/// <param name="tableViewTwo"></param>
/// <param name="idxOne"></param>
/// <param name="idxTwo"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.AssNewWorkEnclosureHeaderEntity model, DataTable tableViewOne, DataTable tableViewTwo, List <string> idxOne, List <string> idxTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
StringBuilder strSql = new StringBuilder( );
EditHeader(SQLString, strSql, model);
LineProductMesEntityu.AssNewWorkEnclosureBodyOneEntity modelOne = new LineProductMesEntityu.AssNewWorkEnclosureBodyOneEntity( );
foreach (DataRow row in tableViewOne.Rows)
{
modelOne.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
modelOne.ANU001 = model.ANT001;
modelOne.ANU002 = row ["ANU002"].ToString( );
modelOne.ANU003 = row ["ANU003"].ToString( );
modelOne.ANU004 = row ["ANU004"].ToString( );
modelOne.ANU005 = row ["ANU005"].ToString( );
modelOne.ANU006 = row ["ANU006"].ToString( );
modelOne.ANU007 = string.IsNullOrEmpty(row ["ANU007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANU007"].ToString( ));
modelOne.ANU008 = row ["ANU008"].ToString( );
modelOne.ANU009 = row ["ANU009"].ToString( );
modelOne.ANU010 = string.IsNullOrEmpty(row ["ANU010"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANU010"].ToString( ));
modelOne.ANU011 = string.IsNullOrEmpty(row ["ANU011"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANU011"].ToString( ));
modelOne.ANU012 = row ["ANU012"].ToString( );
if (modelOne.idx > 0)
{
EditBodyOne(SQLString, strSql, modelOne);
}
else
{
AddBodyOne(SQLString, strSql, modelOne);
}
}
LineProductMesEntityu.AssNewWorkEnclosureBodyTwoEntity modelTwo = new LineProductMesEntityu.AssNewWorkEnclosureBodyTwoEntity( );
foreach (DataRow row in tableViewTwo.Rows)
{
modelTwo.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
modelTwo.ANV001 = model.ANT001;
modelTwo.ANV002 = row ["ANV002"].ToString( );
modelTwo.ANV003 = row ["ANV003"].ToString( );
modelTwo.ANV004 = row ["ANV004"].ToString( );
if (row ["ANV005"] == null || row ["ANV005"].ToString( ) == string.Empty)
{
modelTwo.ANV005 = null;
}
else
{
modelTwo.ANV005 = Convert.ToDateTime(row ["ANV005"]);
}
if (row ["ANV006"] == null || row ["ANV006"].ToString( ) == string.Empty)
{
modelTwo.ANV006 = null;
}
else
{
modelTwo.ANV006 = Convert.ToDateTime(row ["ANV006"]);
}
modelTwo.ANV007 = row ["ANV007"].ToString( );
modelTwo.ANV008 = row ["ANV008"].ToString( );
modelTwo.ANV009 = string.IsNullOrEmpty(row ["ANV009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV009"].ToString( ));
modelTwo.ANV010 = string.IsNullOrEmpty(row ["ANV010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV010"].ToString( ));
modelTwo.ANV011 = row ["ANV011"].ToString( );
if (row ["ANV013"] == null || row ["ANV013"].ToString( ) == string.Empty)
{
modelTwo.ANV013 = null;
}
else
{
modelTwo.ANV013 = Convert.ToDateTime(row ["ANV013"]);
}
if (row ["ANV014"] == null || row ["ANV014"].ToString( ) == string.Empty)
{
modelTwo.ANV014 = null;
}
else
{
modelTwo.ANV014 = Convert.ToDateTime(row ["ANV014"]);
}
modelTwo.ANV015 = string.IsNullOrEmpty(row ["ANV015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV015"].ToString( ));
modelTwo.ANV016 = string.IsNullOrEmpty(row ["ANV016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV016"].ToString( ));
if (string.IsNullOrEmpty(row ["ANV017"].ToString( )))
{
modelTwo.ANV017 = null;
}
else
{
modelTwo.ANV017 = Convert.ToDecimal(row ["ANV017"].ToString( ));
}
if (modelTwo.idx > 0)
{
EditBodyTwo(SQLString, strSql, modelTwo);
}
else
{
ADDBodyTwo(SQLString, strSql, modelTwo);
}
}
foreach (string s in idxOne)
{
DeleteBodyOne(SQLString, strSql, s);
}
foreach (string s in idxTwo)
{
DeleteBodyTwo(SQLString, strSql, s);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <param name="tableViewOne"></param>
/// <param name="tableViewTwo"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.AssNewWorkEnclosureHeaderEntity model, DataTable tableViewOne, DataTable tableViewTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
StringBuilder strSql = new StringBuilder( );
model.ANT001 = getCode( );
model.ANT013 = UserInfoMation.userName;
AddHeader(SQLString, strSql, model);
LineProductMesBll.UserInfoMation.oddNum = model.ANT001;
LineProductMesEntityu.AssNewWorkEnclosureBodyOneEntity modelOne = new LineProductMesEntityu.AssNewWorkEnclosureBodyOneEntity( );
foreach (DataRow row in tableViewOne.Rows)
{
modelOne.ANU001 = model.ANT001;
modelOne.ANU002 = row ["ANU002"].ToString( );
modelOne.ANU003 = row ["ANU003"].ToString( );
modelOne.ANU004 = row ["ANU004"].ToString( );
modelOne.ANU005 = row ["ANU005"].ToString( );
modelOne.ANU006 = row ["ANU006"].ToString( );
modelOne.ANU007 = string.IsNullOrEmpty(row ["ANU007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANU007"].ToString( ));
modelOne.ANU008 = row ["ANU008"].ToString( );
modelOne.ANU009 = row ["ANU009"].ToString( );
modelOne.ANU010 = string.IsNullOrEmpty(row ["ANU010"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANU010"].ToString( ));
modelOne.ANU011 = string.IsNullOrEmpty(row ["ANU011"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANU011"].ToString( ));
modelOne.ANU012 = row ["ANU012"].ToString( );
AddBodyOne(SQLString, strSql, modelOne);
}
LineProductMesEntityu.AssNewWorkEnclosureBodyTwoEntity modelTwo = new LineProductMesEntityu.AssNewWorkEnclosureBodyTwoEntity( );
foreach (DataRow row in tableViewTwo.Rows)
{
modelTwo.ANV001 = model.ANT001;
modelTwo.ANV002 = row ["ANV002"].ToString( );
modelTwo.ANV003 = row ["ANV003"].ToString( );
modelTwo.ANV004 = row ["ANV004"].ToString( );
if (row ["ANV005"] == null || row ["ANV005"].ToString( ) == string.Empty)
{
modelTwo.ANV005 = null;
}
else
{
modelTwo.ANV005 = Convert.ToDateTime(row ["ANV005"]);
}
if (row ["ANV006"] == null || row ["ANV006"].ToString( ) == string.Empty)
{
modelTwo.ANV006 = null;
}
else
{
modelTwo.ANV006 = Convert.ToDateTime(row ["ANV006"]);
}
modelTwo.ANV007 = row ["ANV007"].ToString( );
modelTwo.ANV008 = row ["ANV008"].ToString( );
modelTwo.ANV009 = string.IsNullOrEmpty(row ["ANV009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV009"].ToString( ));
modelTwo.ANV010 = string.IsNullOrEmpty(row ["ANV010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV010"].ToString( ));
modelTwo.ANV011 = row ["ANV011"].ToString( );
if (row ["ANV013"] == null || row ["ANV013"].ToString( ) == string.Empty)
{
modelTwo.ANV013 = null;
}
else
{
modelTwo.ANV013 = Convert.ToDateTime(row ["ANV013"]);
}
if (row ["ANV014"] == null || row ["ANV014"].ToString( ) == string.Empty)
{
modelTwo.ANV014 = null;
}
else
{
modelTwo.ANV014 = Convert.ToDateTime(row ["ANV014"]);
}
modelTwo.ANV015 = string.IsNullOrEmpty(row ["ANV015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV015"].ToString( ));
modelTwo.ANV016 = string.IsNullOrEmpty(row ["ANV016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANV016"].ToString( ));
if (string.IsNullOrEmpty(row ["ANV017"].ToString( )))
{
modelTwo.ANV017 = null;
}
else
{
modelTwo.ANV017 = Convert.ToDecimal(row ["ANV017"].ToString( ));
}
ADDBodyTwo(SQLString, strSql, modelTwo);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
