void AddBodyOne(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkBodyAnnEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into MIKANN(");
strSql.Append("ANN001,ANN002,ANN003,ANN004,ANN005,ANN006,ANN007,ANN008,ANN009,ANN010)");
strSql.Append(" values (");
strSql.Append("@ANN001,@ANN002,@ANN003,@ANN004,@ANN005,@ANN006,@ANN007,@ANN008,@ANN009,@ANN010)");
SqlParameter [] parameters =
{
new SqlParameter("@ANN001", SqlDbType.NVarChar, 20),
new SqlParameter("@ANN002", SqlDbType.NVarChar, 20),
new SqlParameter("@ANN003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANN004", SqlDbType.NVarChar, 50),
new SqlParameter("@ANN005", SqlDbType.NVarChar, 50),
new SqlParameter("@ANN006", SqlDbType.NVarChar, 5),
new SqlParameter("@ANN007", SqlDbType.Int),
new SqlParameter("@ANN008", SqlDbType.Decimal, 12),
new SqlParameter("@ANN009", SqlDbType.Int),
new SqlParameter("@ANN010", SqlDbType.NVarChar, 100)
};
parameters [0].Value = model.ANN001;
parameters [1].Value = model.ANN002;
parameters [2].Value = model.ANN003;
parameters [3].Value = model.ANN004;
parameters [4].Value = model.ANN005;
parameters [5].Value = model.ANN006;
parameters [6].Value = model.ANN007;
parameters [7].Value = model.ANN008;
parameters [8].Value = model.ANN009;
parameters [9].Value = model.ANN010;
SQLString.Add(strSql, parameters);
}
void EditBodyOne(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkBodyAnnEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update MIKANN set ");
strSql.Append("ANN002=@ANN002,");
strSql.Append("ANN003=@ANN003,");
strSql.Append("ANN004=@ANN004,");
strSql.Append("ANN005=@ANN005,");
strSql.Append("ANN006=@ANN006,");
strSql.Append("ANN007=@ANN007,");
strSql.Append("ANN008=@ANN008,");
strSql.Append("ANN009=@ANN009,");
strSql.Append("ANN010=@ANN010 ");
strSql.Append(" WHERE idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@ANN003", SqlDbType.NVarChar, 20),
new SqlParameter("@ANN004", SqlDbType.NVarChar, 50),
new SqlParameter("@ANN005", SqlDbType.NVarChar, 50),
new SqlParameter("@ANN006", SqlDbType.NVarChar, 5),
new SqlParameter("@ANN007", SqlDbType.Int),
new SqlParameter("@ANN008", SqlDbType.Decimal, 12),
new SqlParameter("@ANN009", SqlDbType.Int),
new SqlParameter("@ANN010", SqlDbType.NVarChar, 100),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@ANN002", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.ANN003;
parameters [1].Value = model.ANN004;
parameters [2].Value = model.ANN005;
parameters [3].Value = model.ANN006;
parameters [4].Value = model.ANN007;
parameters [5].Value = model.ANN008;
parameters [6].Value = model.ANN009;
parameters [7].Value = model.ANN010;
parameters [8].Value = model.idx;
parameters [9].Value = model.ANN002;
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));
}
