public FormSanitationCheck( )
{
InitializeComponent( );
header = new MulaolaoLibrary.SanitationCheckHeaderEntity( );
body = new MulaolaoLibrary.SanitationCheckBodyEntity( );
_bll = new MulaolaoBll.Bll.SanitationCheckBll( );
GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, View1, View2 });
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, View1, View2 });
toolStrip1.Items.Remove(toolReview);
toolStrip1.Items.Remove(toolMaintain);
toolStrip1.Items.Remove(toolLibrary);
toolStrip1.Items.Remove(toolStorage);
toolStrip1.Items.Remove(toolcopy);
controlClear( );
controlUnEnable( );
Edit1.DataSource = _bll.getTableWork( );
Edit1.DisplayMember = "DAA002";
Edit1.ValueMember = "DAA002";
Edit2.DataSource = _bll.getTableGroup( );
Edit2.DisplayMember = "DAA002";
Edit2.ValueMember = "DAA002";
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table, List <string> idxList)
{
Hashtable SQLString = new Hashtable( );
EditHeader(SQLString, model);
MulaolaoLibrary.SanitationCheckBodyEntity entity = new MulaolaoLibrary.SanitationCheckBodyEntity( );
entity.SAD001 = model.SAC001;
foreach (DataRow row in table.Rows)
{
entity.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]);
entity.SAD002 = row ["SAD002"].ToString( );
entity.SAD003 = row ["SAD003"].ToString( );
entity.SAD004 = row ["SAD004"].ToString( );
if (row ["SAD005"] == null || row ["SAD005"].ToString( ) == string.Empty)
{
entity.SAD005 = null;
}
else
{
entity.SAD005 = Convert.ToInt32(row ["SAD005"].ToString( ));
}
if (row ["SAD006"] == null || row ["SAD006"].ToString( ) == string.Empty)
{
entity.SAD006 = null;
}
else
{
entity.SAD006 = Convert.ToInt32(row ["SAD006"].ToString( ));
}
entity.SAD007 = row ["SAD007"].ToString( );
entity.SAD008 = row ["SAD008"].ToString( );
entity.SAD009 = row ["SAD009"].ToString( );
//if ( row [ "SAD019" ] == null || row [ "SAD019" ] . ToString ( ) == string . Empty )
// entity . SAD019 = null;
//else
// entity . SAD019 = ( byte? [ ] ) ( row [ "SAD019" ] );
if (entity.idx > 0)
{
EditBody(SQLString, entity);
}
else
{
AddBody(SQLString, entity);
}
}
foreach (string s in idxList)
{
DeleteBody(SQLString, s);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table)
{
Hashtable SQLString = new Hashtable( );
model.SAC001 = getCode( );
AddHeader(SQLString, model);
MulaolaoLibrary.SanitationCheckBodyEntity entity = new MulaolaoLibrary.SanitationCheckBodyEntity( );
entity.SAD001 = model.SAC001;
foreach (DataRow row in table.Rows)
{
entity.SAD002 = row ["SAD002"].ToString( );
entity.SAD003 = row ["SAD003"].ToString( );
entity.SAD004 = row ["SAD004"].ToString( );
if (row ["SAD005"] == null || row ["SAD005"].ToString( ) == string.Empty)
{
entity.SAD005 = null;
}
else
{
entity.SAD005 = Convert.ToInt32(row ["SAD005"].ToString( ));
}
if (row ["SAD006"] == null || row ["SAD006"].ToString( ) == string.Empty)
{
entity.SAD006 = null;
}
else
{
entity.SAD006 = Convert.ToInt32(row ["SAD006"].ToString( ));
}
entity.SAD007 = row ["SAD007"].ToString( );
entity.SAD008 = row ["SAD008"].ToString( );
entity.SAD009 = row ["SAD009"].ToString( );
//if ( row [ "SAD019" ] == null || row [ "SAD019" ] . ToString ( ) == string . Empty )
// entity . SAD019 = null;
//else
// entity . SAD019 = ( byte? [ ] ) ( row [ "SAD019" ] );
AddBody(SQLString, entity);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void AddHeader(Hashtable SQLString, MulaolaoLibrary.SanitationCheckHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into R_SAC(");
strSql.Append("SAC001,SAC002,SAC003,SAC004)");
strSql.Append(" values (");
strSql.Append("@SAC001,@SAC002,@SAC003,@SAC004)");
SqlParameter [] parameters =
{
new SqlParameter("@SAC001", SqlDbType.NVarChar, 20),
new SqlParameter("@SAC002", SqlDbType.NVarChar, 20),
new SqlParameter("@SAC003", SqlDbType.Date, 3),
new SqlParameter("@SAC004", SqlDbType.Date, 3)
};
parameters [0].Value = model.SAC001;
parameters [1].Value = model.SAC002;
parameters [2].Value = model.SAC003;
parameters [3].Value = model.SAC004;
SQLString.Add(strSql, parameters);
}
void EditHeader(Hashtable SQLString, MulaolaoLibrary.SanitationCheckHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update R_SAC set ");
strSql.Append("SAC002=@SAC002,");
strSql.Append("SAC003=@SAC003,");
strSql.Append("SAC004=@SAC004 ");
strSql.Append("WHERE SAC001=@SAC001");
SqlParameter [] parameters =
{
new SqlParameter("@SAC001", SqlDbType.NVarChar, 20),
new SqlParameter("@SAC002", SqlDbType.NVarChar, 20),
new SqlParameter("@SAC003", SqlDbType.Date, 3),
new SqlParameter("@SAC004", SqlDbType.Date, 3)
};
parameters [0].Value = model.SAC001;
parameters [1].Value = model.SAC002;
parameters [2].Value = model.SAC003;
parameters [3].Value = model.SAC004;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table, List <string> idxList)
{
return(dal.Edit(model, table, idxList));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table)
{
return(dal.Save(model, table));
}
