/// <summary>
/// 增加
/// </summary>
/// <param name="table"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
model.INA001 = getCode( );
addHeader(model, SQLString);
MulaolaoLibrary.InvenAdSheetINBEntity body = new MulaolaoLibrary.InvenAdSheetINBEntity( );
body.INB001 = model.INA001;
foreach (DataRow row in table.Rows)
{
body.INB002 = row ["INB002"].ToString( );
body.INB003 = row ["INB003"].ToString( );
body.INB004 = row ["INB004"].ToString( );
body.INB005 = row ["INB005"].ToString( );
body.INB006 = row ["INB006"].ToString( );
body.INB007 = string.IsNullOrEmpty(row ["INB007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB007"]);
body.INB008 = row ["INB008"].ToString( );
body.INB009 = row ["INB009"].ToString( );
body.INB010 = string.IsNullOrEmpty(row ["INB010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB010"]);
body.INB011 = string.IsNullOrEmpty(row ["INB011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB011"]);
body.INB012 = string.IsNullOrEmpty(row ["INB012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB012"]);
body.INB013 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]);
body.INB014 = row ["INB014"].ToString( );
body.INB015 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]);
body.INB016 = row ["INB016"].ToString( );
addBody(body, SQLString);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void editHeader(MulaolaoLibrary.InvenAdSheetINAEntity model, Dictionary <object, object> SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_INA SET ");
strSql.Append("INA003=@INA003 ");
strSql.Append(" WHERE INA001=@INA001");
SqlParameter [] parameters =
{
new SqlParameter("@INA001", SqlDbType.NVarChar, 20),
new SqlParameter("@INA003", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.INA001;
parameters [1].Value = model.INA003;
SQLString.Add(strSql, parameters);
}
public FormInvenAdSheet( )
{
InitializeComponent( );
_bll = new MulaolaoBll.Bll.InvenAdSheetBll( );
model = new MulaolaoLibrary.InvenAdSheetINAEntity( );
body = new MulaolaoLibrary.InvenAdSheetINBEntity( );
toolStrip1.Items.Remove(toolPrint);
toolStrip1.Items.Remove(toolExport);
toolStrip1.Items.Remove(toolLibrary);
toolStrip1.Items.Remove(toolStorage);
toolStrip1.Items.Remove(toolcopy);
controlUnEnable( );
dt = MulaolaoBll.Drity.GetDt( );
label45.Visible = false;
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="table"></param>
/// <param name="model"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model, List <string> strList)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
editHeader(model, SQLString);
MulaolaoLibrary.InvenAdSheetINBEntity body = new MulaolaoLibrary.InvenAdSheetINBEntity( );
body.INB001 = model.INA001;
foreach (DataRow row in table.Rows)
{
body.id = string.IsNullOrEmpty(row ["id"].ToString( )) == true ? 0 : Convert.ToInt32(row ["id"]);
body.INB002 = row ["INB002"].ToString( );
body.INB003 = row ["INB003"].ToString( );
body.INB004 = row ["INB004"].ToString( );
body.INB005 = row ["INB005"].ToString( );
body.INB006 = row ["INB006"].ToString( );
body.INB007 = string.IsNullOrEmpty(row ["INB007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB007"]);
body.INB008 = row ["INB008"].ToString( );
body.INB009 = row ["INB009"].ToString( );
body.INB010 = string.IsNullOrEmpty(row ["INB010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB010"]);
body.INB011 = string.IsNullOrEmpty(row ["INB011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB011"]);
body.INB012 = string.IsNullOrEmpty(row ["INB012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB012"]);
body.INB013 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]);
body.INB014 = row ["INB014"].ToString( );
body.INB015 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]);
body.INB016 = row ["INB016"].ToString( );
if (body.id <= 1)
{
addBody(body, SQLString);
}
else
{
editBody(body, SQLString);
}
}
foreach (string s in strList)
{
deleteBody(s, SQLString);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void addHeader(MulaolaoLibrary.InvenAdSheetINAEntity model, Dictionary <object, object> SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into R_INA(");
strSql.Append("INA001,INA003,INA004,INA005)");
strSql.Append(" values (");
strSql.Append("@INA001,@INA003,@INA004,@INA005)");
SqlParameter [] parameters =
{
new SqlParameter("@INA001", SqlDbType.NVarChar, 20),
new SqlParameter("@INA003", SqlDbType.NVarChar, 20),
new SqlParameter("@INA004", SqlDbType.Date, 3),
new SqlParameter("@INA005", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.INA001;
parameters [1].Value = model.INA003;
parameters [2].Value = model.INA004;
parameters [3].Value = model.INA005;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="table"></param>
/// <param name="model"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model, List <string> strList)
{
return(dal.Edit(table, model, strList));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="table"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model)
{
return(dal.Add(table, model));
}
