void ADDBodyTwo(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkEnclosureBodyTwoEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into MIKANV(");
strSql.Append("ANV001,ANV002,ANV003,ANV004,ANV005,ANV006,ANV007,ANV008,ANV009,ANV010,ANV011,ANV013,ANV014,ANV015,ANV016,ANV017)");
strSql.Append(" values (");
strSql.Append("@ANV001,@ANV002,@ANV003,@ANV004,@ANV005,@ANV006,@ANV007,@ANV008,@ANV009,@ANV010,@ANV011,@ANV013,@ANV014,@ANV015,@ANV016,@ANV017)");
SqlParameter [] parameters =
{
new SqlParameter("@ANV001", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV004", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV005", SqlDbType.DateTime),
new SqlParameter("@ANV006", SqlDbType.DateTime),
new SqlParameter("@ANV007", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV008", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV009", SqlDbType.Decimal),
new SqlParameter("@ANV010", SqlDbType.Decimal),
new SqlParameter("@ANV011", SqlDbType.NVarChar, 100),
new SqlParameter("@ANV013", SqlDbType.DateTime),
new SqlParameter("@ANV014", SqlDbType.DateTime),
new SqlParameter("@ANV015", SqlDbType.Decimal),
new SqlParameter("@ANV016", SqlDbType.Decimal),
new SqlParameter("@ANV017", SqlDbType.Decimal)
};
parameters [0].Value = model.ANV001;
parameters [1].Value = model.ANV002;
parameters [2].Value = model.ANV003;
parameters [3].Value = model.ANV004;
parameters [4].Value = model.ANV005;
parameters [5].Value = model.ANV006;
parameters [6].Value = model.ANV007;
parameters [7].Value = model.ANV008;
parameters [8].Value = model.ANV009;
parameters [9].Value = model.ANV010;
parameters [10].Value = model.ANV011;
parameters [11].Value = model.ANV013;
parameters [12].Value = model.ANV014;
parameters [13].Value = model.ANV015;
parameters [14].Value = model.ANV016;
parameters [15].Value = model.ANV017;
SQLString.Add(strSql, parameters);
}
void EditBodyTwo(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkEnclosureBodyTwoEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update MIKANV set ");
strSql.Append("ANV002=@ANV002,");
strSql.Append("ANV003=@ANV003,");
strSql.Append("ANV004=@ANV004,");
strSql.Append("ANV005=@ANV005,");
strSql.Append("ANV006=@ANV006,");
strSql.Append("ANV007=@ANV007,");
strSql.Append("ANV008=@ANV008,");
strSql.Append("ANV009=@ANV009,");
strSql.Append("ANV010=@ANV010,");
strSql.Append("ANV011=@ANV011,");
strSql.Append("ANV013=@ANV013,");
strSql.Append("ANV014=@ANV014,");
strSql.Append("ANV015=@ANV015,");
strSql.Append("ANV016=@ANV016,");
strSql.Append("ANV017=@ANV017 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@ANV003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV004", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV005", SqlDbType.DateTime),
new SqlParameter("@ANV006", SqlDbType.DateTime),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@ANV002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV007", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV008", SqlDbType.NVarChar, 20),
new SqlParameter("@ANV009", SqlDbType.Decimal, 9),
new SqlParameter("@ANV010", SqlDbType.Decimal, 9),
new SqlParameter("@ANV011", SqlDbType.NVarChar, 100),
new SqlParameter("@ANV013", SqlDbType.DateTime),
new SqlParameter("@ANV014", SqlDbType.DateTime),
new SqlParameter("@ANV015", SqlDbType.Decimal, 9),
new SqlParameter("@ANV016", SqlDbType.Decimal, 9),
new SqlParameter("@ANV017", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.ANV003;
parameters [1].Value = model.ANV004;
parameters [2].Value = model.ANV005;
parameters [3].Value = model.ANV006;
parameters [4].Value = model.idx;
parameters [5].Value = model.ANV002;
parameters [6].Value = model.ANV007;
parameters [7].Value = model.ANV008;
parameters [8].Value = model.ANV009;
parameters [9].Value = model.ANV010;
parameters [10].Value = model.ANV011;
parameters [11].Value = model.ANV013;
parameters [12].Value = model.ANV014;
parameters [13].Value = model.ANV015;
parameters [14].Value = model.ANV016;
parameters [15].Value = model.ANV017;
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));
}
