void AddHeader(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QuoEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_QUO(");
strSql.Append("QUO001,QUO002,QUO003,QUO004,QUO005,QUO006,QUO007,QUO008,QUO009,QUO010)");
strSql.Append(" values (");
strSql.Append("@QUO001,@QUO002,@QUO003,@QUO004,@QUO005,@QUO006,@QUO007,@QUO008,@QUO009,@QUO010)");
SqlParameter [] parameters =
{
new SqlParameter("@QUO001", SqlDbType.NVarChar, 20),
new SqlParameter("@QUO002", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO003", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO004", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO005", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO006", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO007", SqlDbType.Int, 4),
new SqlParameter("@QUO008", SqlDbType.Date, 3),
new SqlParameter("@QUO009", SqlDbType.Image),
new SqlParameter("@QUO010", SqlDbType.NVarChar, 50)
};
parameters [0].Value = model.QUO001;
parameters [1].Value = model.QUO002;
parameters [2].Value = model.QUO003;
parameters [3].Value = model.QUO004;
parameters [4].Value = model.QUO005;
parameters [5].Value = model.QUO006;
parameters [6].Value = model.QUO007;
parameters [7].Value = model.QUO008;
parameters [8].Value = model.QUO009;
parameters [9].Value = model.QUO010;
SQLString.Add(strSql, parameters);
}
protected override void select( )
{
SelectAll.FormQuotationQuery form = new SelectAll.FormQuotationQuery( );
if (form.ShowDialog( ) == DialogResult.OK)
{
_quo.QUO001 = form.getOdd;
if (_quo.QUO001 == null || _quo.QUO001 == string.Empty)
{
return;
}
strWhere = "1=1";
strWhere = strWhere + " AND QUO001='" + _quo.QUO001 + "'";
_quo = _bll.getModel(strWhere);
if (_quo == null)
{
return;
}
setValue( );
strWhere = "1=1";
strWhere += " AND QUR001='" + _quo.QUO001 + "'";
tableView = _bll.getTableView(strWhere);
gridControl1.DataSource = tableView;
toolAdd.Enabled = toolSelect.Enabled = toolDelete.Enabled = toolUpdate.Enabled = toolPrint.Enabled = toolExport.Enabled = toolLibrary.Enabled = toolStorage.Enabled = toolMaintain.Enabled = toolcopy.Enabled = toolReview.Enabled = true;
toolSave.Enabled = toolCancel.Enabled = false;
}
base.select( );
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="_quo"></param>
/// <param name="table"></param>
/// <param name="state"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.QuoEntity _quo, DataTable table, string state, List <string> idxList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (state.Equals("add"))
{
_quo.QUO001 = getOddNum( );
AddHeader(SQLString, strSql, _quo);
}
else
{
EditHeader(SQLString, strSql, _quo);
}
MulaolaoLibrary.QupEntity _qup = new MulaolaoLibrary.QupEntity( );
_qup.QUR001 = _quo.QUO001;
for (int i = 0; i < table.Rows.Count; i++)
{
_qup.QUR002 = table.Rows [i] ["QUR002"].ToString( );
_qup.QUR003 = table.Rows [i] ["QUR003"].ToString( );
_qup.QUR004 = table.Rows [i] ["QUR004"].ToString( );
_qup.QUR005 = table.Rows [i] ["QUR005"].ToString( );
_qup.QUR006 = string.IsNullOrEmpty(table.Rows [i] ["QUR006"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR006"].ToString( ));
_qup.QUR007 = table.Rows [i] ["QUR007"].ToString( );
_qup.QUR008 = table.Rows [i] ["QUR008"].ToString( );
_qup.QUR009 = table.Rows [i] ["QUR009"].ToString( );
_qup.QUR010 = string.IsNullOrEmpty(table.Rows [i] ["QUR010"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR010"].ToString( ));
_qup.QUR011 = string.IsNullOrEmpty(table.Rows [i] ["QUR011"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR011"].ToString( ));
_qup.QUR012 = string.IsNullOrEmpty(table.Rows [i] ["QUR012"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR012"].ToString( ));
_qup.QUR013 = string.IsNullOrEmpty(table.Rows [i] ["QUR013"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR013"].ToString( ));
_qup.QUR014 = string.IsNullOrEmpty(table.Rows [i] ["QUR014"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR014"].ToString( ));
_qup.QUR016 = string.IsNullOrEmpty(table.Rows [i] ["QUR016"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR016"].ToString( ));
_qup.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
_qup.QUR015 = table.Rows [i] ["QUR015"].ToString( );
if (_qup.idx < 1)
{
AddBody(SQLString, strSql, _qup);
}
else
{
EditBody(SQLString, strSql, _qup);
}
}
if (idxList.Count > 0)
{
foreach (string s in idxList)
{
DeleteBody(SQLString, strSql, s);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
public FormQuotation( )
{
InitializeComponent( );
_bll = new MulaolaoBll.Bll.QuoBll( );
_quo = new MulaolaoLibrary.QuoEntity( );
_qup = new MulaolaoLibrary.QupEntity( );
controlUnEnable( );
InitData( );
GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, ViewFor });
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, ViewFor });
dt = Drity.GetDt( );
}
public MulaolaoLibrary.QuoEntity getModel(DataRow row)
{
MulaolaoLibrary.QuoEntity model = new MulaolaoLibrary.QuoEntity( );
if (row != null)
{
if (row ["QUO001"] != null)
{
model.QUO001 = row ["QUO001"].ToString( );
}
if (row ["QUO002"] != null)
{
model.QUO002 = row ["QUO002"].ToString( );
}
if (row ["QUO003"] != null)
{
model.QUO003 = row ["QUO003"].ToString( );
}
if (row ["QUO004"] != null)
{
model.QUO004 = row ["QUO004"].ToString( );
}
if (row ["QUO005"] != null)
{
model.QUO005 = row ["QUO005"].ToString( );
}
if (row ["QUO006"] != null)
{
model.QUO006 = row ["QUO006"].ToString( );
}
if (row ["QUO007"] != null && row ["QUO007"].ToString( ) != "")
{
model.QUO007 = int.Parse(row ["QUO007"].ToString( ));
}
if (row ["QUO008"] != null && row ["QUO008"].ToString( ) != "")
{
model.QUO008 = DateTime.Parse(row ["QUO008"].ToString( ));
}
if (row ["QUO009"] != null && row ["QUO009"].ToString( ) != "")
{
model.QUO009 = ( byte [] )row ["QUO009"];
}
if (row ["QUO010"] != null && row ["QUO010"].ToString( ) != "")
{
model.QUO010 = row ["QUO010"].ToString( );
}
}
return(model);
}
void EditHeader(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QuoEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_QUO set ");
strSql.Append("QUO002=@QUO002,");
strSql.Append("QUO003=@QUO003,");
strSql.Append("QUO004=@QUO004,");
strSql.Append("QUO005=@QUO005,");
strSql.Append("QUO006=@QUO006,");
strSql.Append("QUO007=@QUO007,");
strSql.Append("QUO008=@QUO008,");
strSql.Append("QUO009=@QUO009,");
strSql.Append("QUO010=@QUO010 ");
strSql.Append(" where QUO001=@QUO001");
SqlParameter [] parameters =
{
new SqlParameter("@QUO001", SqlDbType.NVarChar, 20),
new SqlParameter("@QUO002", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO003", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO004", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO005", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO006", SqlDbType.NVarChar, 50),
new SqlParameter("@QUO007", SqlDbType.Int, 4),
new SqlParameter("@QUO008", SqlDbType.Date, 3),
new SqlParameter("@QUO009", SqlDbType.Image),
new SqlParameter("@QUO010", SqlDbType.NVarChar, 50),
};
parameters [0].Value = model.QUO001;
parameters [1].Value = model.QUO002;
parameters [2].Value = model.QUO003;
parameters [3].Value = model.QUO004;
parameters [4].Value = model.QUO005;
parameters [5].Value = model.QUO006;
parameters [6].Value = model.QUO007;
parameters [7].Value = model.QUO008;
parameters [8].Value = model.QUO009;
parameters [9].Value = model.QUO010;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="_quo"></param>
/// <param name="table"></param>
/// <param name="state"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.QuoEntity _quo, DataTable table, string state, List <string> idxList)
{
return(dal.Save(_quo, table, state, idxList));
}
