//确认
private void button2_Click(object sender, System.EventArgs e)
{
if (string.IsNullOrEmpty(lookUpEdit14.Text))
{
MessageBox.Show("物料类别不可为空");
return;
}
if (string.IsNullOrEmpty(textBox1.Text))
{
MessageBox.Show("领用数量不可为空");
return;
}
if (string.IsNullOrEmpty(lookUpEdit2.Text))
{
MessageBox.Show("领用人不可为空");
return;
}
_was = new MulaolaoLibrary.WarehouseReceiptWASEntity( );
_was.WAS001 = lookUpEdit14.Text;
_was.WAS004 = textBox8.Text;
_was.WAS002 = dateTimePicker1.Value;
_was.WAS005 = textBox7.Text;
_was.WAS006 = string.IsNullOrEmpty(textBox1.Text) == true ? 0 : Convert.ToInt32(textBox1.Text);
_was.WAS007 = string.IsNullOrEmpty(textBox2.Text) == true ? 0 : Convert.ToDecimal(textBox2.Text);
_was.WAS008 = string.IsNullOrEmpty(textBox3.Text) == true ? 0 : Convert.ToDecimal(textBox3.Text);
_was.WAS009 = lookUpEdit2.Text;
_was.WAS010 = richTextBox1.Text;
_was.WAS012 = string.IsNullOrEmpty(lookUpEdit14.EditValue.ToString( )) == true ? 0 : Convert.ToInt32(lookUpEdit14.EditValue.ToString( ));
if (this.Text.Equals("新增"))
{
result = _bll.AddL(_was);
if (result == true)
{
MessageBox.Show("新增成功");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("新增失败");
}
}
else if (this.Text.Equals("编辑"))
{
_was.idx = string.IsNullOrEmpty(lookUpEdit14.Tag.ToString( )) == true ? 0 : Convert.ToInt32(lookUpEdit14.Tag);
result = _bll.EditL(_was);
if (result == true)
{
MessageBox.Show("编辑成功");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("编辑失败");
}
}
}
public MulaolaoLibrary.WarehouseReceiptWASEntity getModelL(DataRow row)
{
MulaolaoLibrary.WarehouseReceiptWASEntity model = new MulaolaoLibrary.WarehouseReceiptWASEntity( );
if (row != null)
{
if (row ["idx"] != null && row ["idx"].ToString( ) != "")
{
model.idx = int.Parse(row ["idx"].ToString( ));
}
if (row ["WAS001"] != null && row ["WAS001"].ToString( ) != "")
{
model.WAS001 = row ["WAS001"].ToString( );
}
if (row ["WAS002"] != null && row ["WAS002"].ToString( ) != "")
{
model.WAS002 = DateTime.Parse(row ["WAS002"].ToString( ));
}
//if ( row [ "WAS003" ] != null && row [ "WAS003" ] . ToString ( ) != "" )
// model . WAS003 = row [ "WAS003" ] . ToString ( );
if (row ["WAS004"] != null && row ["WAS004"].ToString( ) != "")
{
model.WAS004 = row ["WAS004"].ToString( );
}
if (row ["WAS005"] != null && row ["WAS005"].ToString( ) != "")
{
model.WAS005 = row ["WAS005"].ToString( );
}
if (row ["WAS006"] != null && row ["WAS006"].ToString( ) != "")
{
model.WAS006 = int.Parse(row ["WAS006"].ToString( ));
}
if (row ["WAS007"] != null && row ["WAS007"].ToString( ) != "")
{
model.WAS007 = decimal.Parse(row ["WAS007"].ToString( ));
}
if (row ["WAS008"] != null && row ["WAS008"].ToString( ) != "")
{
model.WAS008 = decimal.Parse(row ["WAS008"].ToString( ));
}
if (row ["WAS009"] != null && row ["WAS009"].ToString( ) != "")
{
model.WAS009 = row ["WAS009"].ToString( );
}
if (row ["WAS010"] != null && row ["WAS010"].ToString( ) != "")
{
model.WAS010 = row ["WAS010"].ToString( );
}
if (row ["WAS012"] != null && row ["WAS012"].ToString( ) != "")
{
model.WAS012 = int.Parse(row ["WAS012"].ToString( ));
}
}
return(model);
}
/// <summary>
/// 编辑记录
/// </summary>
/// <param name="_was"></param>
/// <returns></returns>
public bool EditL(MulaolaoLibrary.WarehouseReceiptWASEntity _was)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQWAS SET ");
strSql.Append("WAS001=@WAS001,");
strSql.Append("WAS002=@WAS002,");
strSql.Append("WAS004=@WAS004,");
strSql.Append("WAS005=@WAS005,");
strSql.Append("WAS006=@WAS006,");
strSql.Append("WAS007=@WAS007,");
strSql.Append("WAS008=@WAS008,");
strSql.Append("WAS009=@WAS009,");
strSql.Append("WAS010=@WAS010,");
strSql.Append("WAS012=@WAS012 ");
strSql.Append("WHERE idx=@idx");
SqlParameter [] parameter =
{
new SqlParameter("@WAS001", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS002", SqlDbType.Date),
new SqlParameter("@WAS004", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS005", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS006", SqlDbType.Decimal, 8),
new SqlParameter("@WAS007", SqlDbType.Decimal, 10),
new SqlParameter("@WAS008", SqlDbType.Decimal, 10),
new SqlParameter("@WAS009", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS010", SqlDbType.NVarChar, 50),
new SqlParameter("@WAS012", SqlDbType.Int),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter [0].Value = _was.WAS001;
parameter [1].Value = _was.WAS002;
parameter [2].Value = _was.WAS004;
parameter [3].Value = _was.WAS005;
parameter [4].Value = _was.WAS006;
parameter [5].Value = _was.WAS007;
parameter [6].Value = _was.WAS008;
parameter [7].Value = _was.WAS009;
parameter [8].Value = _was.WAS010;
parameter [9].Value = _was.WAS012;
parameter [10].Value = _was.idx;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
bool checkView( )
{
result = true;
gridView2.CloseEditor( );
gridView2.UpdateCurrentRow( );
DataRow row;
MulaolaoLibrary.WarehouseReceiptWASEntity _was = new MulaolaoLibrary.WarehouseReceiptWASEntity( );
for (int i = 0; i < gridView2.DataRowCount; i++)
{
row = gridView2.GetDataRow(i);
_was.WAS006 = string.IsNullOrEmpty(row ["U0"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["U0"].ToString( ));
_was.WAS008 = string.IsNullOrEmpty(row ["WAR006"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["WAR006"].ToString( ));
_was.WAS001 = row ["U3"].ToString( );
_was.WAS007 = string.IsNullOrEmpty(row ["WAR009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["WAR009"].ToString( ));
_was.WAS009 = row ["U1"].ToString( );
row.ClearErrors( );
if (!string.IsNullOrEmpty(_was.WAS009) && string.IsNullOrEmpty(_was.WAS001))
{
row.SetColumnError("U3", "不可为空");
result = false;
break;
}
//if ( _was . WAS006 <= 0 )
//{
// row . SetColumnError ( "U0" ,"数量必须大于0" );
// result = false;
// break;
//}
if (_was.WAS008 < _was.WAS006)
{
row.SetColumnError("U0", "数量大于剩余数量");
result = false;
break;
}
//if ( _was . WAS007 <= 0 )
//{
// row . SetColumnError ( "WAR009" ,"单价必须大于0" );
// result = false;
// break;
//}
}
return(result);
}
void getWas( )
{
_was = _bll.GetDataTableL(_was.idx);
if (_was == null)
{
return;
}
//lookUpEdit14 . Text = _was . WAS001;
//if ( _was . WAS002 != null )
// dateTimePicker2 . Value = _was . WAS002;
//lookUpEdit8 . Text = _was . WAS009;
//textBox9 . Text = _was . WAS006 . ToString ( );
//textBox11 . Text = _was . WAS007 . ToString ( );
//textBox10 . Text = _was . WAS008 . ToString ( );
//textBox12 . Text = _was . WAS010;
//textBox7 . Text = _was . WAS005;
//textBox6 . Text = _was . WAS004;
}
/// <summary>
/// 增加记录
/// </summary>
/// <param name="_was"></param>
/// <returns></returns>
public bool AddL(MulaolaoLibrary.WarehouseReceiptWASEntity _was)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQWAS (");
strSql.Append("WAS001,WAS002,WAS004,WAS005,WAS006,WAS007,WAS008,WAS009,WAS010,WAS012) ");
strSql.Append("VALUES (");
strSql.Append("@WAS001,@WAS002,@WAS004,@WAS005,@WAS006,@WAS007,@WAS008,@WAS009,@WAS010,@WAS012) ");
SqlParameter [] parameter =
{
new SqlParameter("@WAS001", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS002", SqlDbType.Date),
new SqlParameter("@WAS004", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS005", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS006", SqlDbType.Decimal, 8),
new SqlParameter("@WAS007", SqlDbType.Decimal, 10),
new SqlParameter("@WAS008", SqlDbType.Decimal, 10),
new SqlParameter("@WAS009", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS010", SqlDbType.NVarChar, 50),
new SqlParameter("@WAS012", SqlDbType.Int)
};
parameter [0].Value = _was.WAS001;
parameter [1].Value = _was.WAS002;
parameter [2].Value = _was.WAS004;
parameter [3].Value = _was.WAS005;
parameter [4].Value = _was.WAS006;
parameter [5].Value = _was.WAS007;
parameter [6].Value = _was.WAS008;
parameter [7].Value = _was.WAS009;
parameter [8].Value = _was.WAS010;
parameter [9].Value = _was.WAS012;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public WarehouseReceiptAdd(string text, MulaolaoLibrary.WarehouseReceiptWASEntity _was)
{
InitializeComponent( );
this.Text = text;
if (this.Text.Equals("编辑"))
{
this._was = _was;
}
da = _bll.GetDataTableOnly("idx,WAR001,WAR003,WAR004,WAR005,WAR007,WAR009,WAR010,WAR011", "R_PQWAR");
lookUpEdit14.Properties.DataSource = da;
lookUpEdit14.Properties.DisplayMember = "WAR001";
lookUpEdit14.Properties.ValueMember = "idx";
//lookUpEdit3 . Properties . DataSource = _bll . GetDataTableOnly ( "WAR004" ,"R_PQWAR" );
//lookUpEdit3 . Properties . DisplayMember = "WAR004";
//lookUpEdit4 . Properties . DataSource = _bll . GetDataTableOnly ( "WAR005" ,"R_PQWAR" );
//lookUpEdit4 . Properties . DisplayMember = "WAR005";
lookUpEdit2.Properties.DataSource = _bll.GetDataTablePerson( );
lookUpEdit2.Properties.DisplayMember = "DBA002";
lookUpEdit2.Properties.ValueMember = "DBA001";
}
public FormWarehouseReceipt( )
{
InitializeComponent( );
GridViewMoHuSelect.SetFilter(gridView1);
GridViewMoHuSelect.SetFilter(gridView2);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
button3.Enabled = button4.Enabled = button5.Enabled = button6.Enabled = /*button7 . Enabled = button8 . Enabled =*/ false;
_war = new MulaolaoLibrary.WarehouseReceiptWAREntity( );
_was = new MulaolaoLibrary.WarehouseReceiptWASEntity( );
_bll = new MulaolaoBll.Bll.WarehouseReceiptBll( );
tableOne = new DataTable( );
tableTwo = new DataTable( );
comboBox1.DataSource = _bll.GetDataTableOnly("WAR001", "R_PQWAR");
comboBox1.DisplayMember = "WAR001";
comboBox2.DataSource = _bll.GetDataTableOnly("WAR004", "R_PQWAR");
comboBox2.DisplayMember = "WAR004";
comboBox3.DataSource = _bll.GetDataTableOnly("WAR005", "R_PQWAR");
comboBox3.DisplayMember = "WAR005";
comboBox4.DataSource = _bll.GetDataTableOnly("WAR010", "R_PQWAR");
comboBox4.DisplayMember = "WAR010";
comboBox5.DataSource = _bll.GetDataTableOnly("WAR007", "R_PQWAR");
comboBox5.DisplayMember = "WAR007";
lookUpEdit7.Properties.DataSource = _bll.GetDataTablePerson( );
lookUpEdit7.Properties.DisplayMember = "DBA002";
lookUpEdit3.Properties.DataSource = _bll.GetDataTablePerson( );
lookUpEdit3.Properties.DisplayMember = "DBA002";
tableQuery = _bll.GetDataTableOnly("idx,WAR001,WAR003,WAR004,WAR005,WAR007,WAR009,WAR010,WAR011", "R_PQWAR");
//lookUpEdit14 . Properties . DataSource = tableQuery;
//lookUpEdit14 . Properties . DisplayMember = "WAR001";
//lookUpEdit14 . Properties . ValueMember = "idx";
//lookUpEdit8 . Properties . DataSource = _bll . GetDataTablePerson ( );
//lookUpEdit8 . Properties . DisplayMember = "DBA002";
}
/// <summary>
/// 入库
/// </summary>
/// <param name="table"></param>
/// <param name="dt"></param>
/// <returns></returns>
public bool Library(DataTable table, DateTime dt)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
string nameOf = string.Empty;
MulaolaoLibrary.WarehouseReceiptWASEntity _was = new MulaolaoLibrary.WarehouseReceiptWASEntity( );
for (int i = 0; i < table.Rows.Count; i++)
{
_was.WAS001 = table.Rows [i] ["WAR001"].ToString( );
_was.WAS002 = dt;
_was.WAS004 = table.Rows [i] ["WAR004"].ToString( );
_was.WAS005 = table.Rows [i] ["WAR005"].ToString( );
_was.WAS006 = string.IsNullOrEmpty(table.Rows [i] ["U0"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["U0"].ToString( ));
_was.WAS007 = priceTwo(_was.WAS001, _was.WAS004);
_was.WAS008 = string.IsNullOrEmpty(table.Rows [i] ["WAR009"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["WAR009"].ToString( ));
_was.WAS009 = table.Rows [i] ["U1"].ToString( );
_was.WAS010 = table.Rows [i] ["U2"].ToString( );
_was.WAS012 = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
_was.WAS013 = table.Rows [i] ["U3"].ToString( );
nameOf = table.Rows [i] ["U4"].ToString( );
if (_was.WAS006 > 0 && !string.IsNullOrEmpty(_was.WAS009))
{
strSql = new StringBuilder( );
SqlParameter [] parameter = null;
if (nameOf.Equals("301"))
{
strSql.Append("INSERT INTO R_PQWAS (");
strSql.Append("WAS001,WAS002,WAS004,WAS005,WAS006,WAS007,WAS008,WAS009,WAS010,WAS012,WAS013) ");
strSql.Append("VALUES (");
strSql.Append("@WAS001,@WAS002,@WAS004,@WAS005,@WAS006,@WAS007,@WAS008,@WAS009,@WAS010,@WAS012,@WAS013) ");
parameter = new SqlParameter [] {
new SqlParameter("@WAS001", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS002", SqlDbType.Date),
new SqlParameter("@WAS004", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS005", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS006", SqlDbType.Decimal, 8),
new SqlParameter("@WAS007", SqlDbType.Decimal, 10),
new SqlParameter("@WAS008", SqlDbType.Decimal, 10),
new SqlParameter("@WAS009", SqlDbType.NVarChar, 20),
new SqlParameter("@WAS010", SqlDbType.NVarChar, 50),
new SqlParameter("@WAS012", SqlDbType.Int),
new SqlParameter("@WAS013", SqlDbType.NVarChar, 20)
};
parameter [0].Value = _was.WAS001;
parameter [1].Value = _was.WAS002;
parameter [2].Value = _was.WAS004;
parameter [3].Value = _was.WAS005;
parameter [4].Value = _was.WAS006;
parameter [5].Value = _was.WAS007;
parameter [6].Value = _was.WAS008;
parameter [7].Value = _was.WAS009;
parameter [8].Value = _was.WAS010;
parameter [9].Value = _was.WAS012;
parameter [10].Value = _was.WAS013;
}
else
{
strSql.Append("INSERT INTO R_PQAD (");
strSql.Append("AD01,AD17,AD02,AD03,AD04,AD05,AD06,AD07,AD08,AD09,AD10,AD11,AD12,AD13,AD14,AD15,AD16) ");
strSql.Append("VALUES (");
strSql.Append("@AD01,@AD17,@AD02,@AD03,@AD04,@AD05,@AD06,@AD07,@AD08,@AD09,@AD10,@AD11,@AD12,@AD13,@AD14,@AD15,@AD16) ");
parameter = new SqlParameter [] {
new SqlParameter("@AD01", SqlDbType.NVarChar, 20),
new SqlParameter("@AD17", SqlDbType.NVarChar, 20),
new SqlParameter("@AD02", SqlDbType.NVarChar, 100),
new SqlParameter("@AD03", SqlDbType.NVarChar, 100),
new SqlParameter("@AD04", SqlDbType.NVarChar, 100),
new SqlParameter("@AD05", SqlDbType.BigInt),
new SqlParameter("@AD06", SqlDbType.NVarChar, 100),
new SqlParameter("@AD07", SqlDbType.NVarChar, 100),
new SqlParameter("@AD08", SqlDbType.NVarChar, 20),
new SqlParameter("@AD09", SqlDbType.Decimal, 8),
new SqlParameter("@AD10", SqlDbType.Decimal, 10),
new SqlParameter("@AD11", SqlDbType.Decimal, 10),
new SqlParameter("@AD12", SqlDbType.Decimal, 10),
new SqlParameter("@AD13", SqlDbType.Date, 3),
new SqlParameter("@AD14", SqlDbType.NVarChar, 255),
new SqlParameter("@AD15", SqlDbType.NVarChar, 20),
new SqlParameter("@AD16", SqlDbType.Date, 3)
};
parameter [0].Value = nameOf;
parameter [1].Value = "R_301";
parameter [2].Value = string.Empty;
parameter [3].Value = string.Empty;
parameter [4].Value = string.Empty;
parameter [5].Value = 0;
parameter [6].Value = _was.WAS001;
parameter [7].Value = _was.WAS004;
parameter [8].Value = _was.WAS005;
parameter [9].Value = 0;
parameter [10].Value = 0;
parameter [11].Value = _was.WAS008;
parameter [12].Value = _was.WAS006;
parameter [13].Value = DateTime.Now;
parameter [14].Value = string.Empty;
parameter [15].Value = string.Empty;
parameter [16].Value = DateTime.Now;
}
SQLString.Add(strSql, parameter);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 编辑记录
/// </summary>
/// <param name="_was"></param>
/// <returns></returns>
public bool EditL(MulaolaoLibrary.WarehouseReceiptWASEntity _was)
{
return(_dao.EditL(_was));
}
