public R_FrmDetailedDeduction( )
{
InitializeComponent( );
_model = new MulaolaoLibrary.DetailedDeductionLibrary( );
_wy = new MulaolaoLibrary.DetailedDeductionWYLibrary( );
_bll = new MulaolaoBll.Bll.DetailedDeductionBll( );
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView3 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.DetailedDeductionLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQWZ (");
strSql.Append("WZ001,WZ002,WZ003,WZ004,WZ005,WZ006,WZ007,WZ008,WZ009,WZ010,WZ011,WZ012,WZ013,WZ014,WZ015)");
strSql.Append(" VALUES (");
strSql.Append("@WZ001,@WZ002,@WZ003,@WZ004,@WZ005,@WZ006,@WZ007,@WZ008,@WZ009,@WZ010,@WZ011,@WZ012,@WZ013,@WZ014,@WZ015);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter[] parameter =
{
new SqlParameter("@WZ001", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ002", SqlDbType.Date),
new SqlParameter("@WZ003", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ004", SqlDbType.NVarChar, 50),
new SqlParameter("@WZ005", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ006", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ007", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ008", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ009", SqlDbType.NVarChar, 50),
new SqlParameter("@WZ010", SqlDbType.Decimal),
new SqlParameter("@WZ011", SqlDbType.Decimal),
new SqlParameter("@WZ012", SqlDbType.Decimal),
new SqlParameter("@WZ013", SqlDbType.Decimal),
new SqlParameter("@WZ014", SqlDbType.Decimal),
new SqlParameter("@WZ015", SqlDbType.NVarChar, 100)
};
parameter[0].Value = _model.WZ001;
parameter[1].Value = _model.WZ002;
parameter[2].Value = _model.WZ003;
parameter[3].Value = _model.WZ004;
parameter[4].Value = _model.WZ005;
parameter[5].Value = _model.WZ006;
parameter[6].Value = _model.WZ007;
parameter[7].Value = _model.WZ008;
parameter[8].Value = _model.WZ009;
parameter[9].Value = _model.WZ010;
parameter[10].Value = _model.WZ011;
parameter[11].Value = _model.WZ012;
parameter[12].Value = _model.WZ013;
parameter[13].Value = _model.WZ014;
parameter[14].Value = _model.WZ015;
int id = SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter);
return(id);
}
protected override void select( )
{
base.select( );
_model = new MulaolaoLibrary.DetailedDeductionLibrary( );
SelectAll.DetailedDeductionAll query = new SelectAll.DetailedDeductionAll( );
query.StartPosition = FormStartPosition.CenterScreen;
query.PassDataBetweenForm += new SelectAll.DetailedDeductionAll.PassDataBetweenFormHandler(query_PassDataBetweenFrom);
query.ShowDialog( );
strWhere = "1=1";
if (sign == "1")
{
if (sList.Count > 0)
{
string s = "";
foreach (string id in sList)
{
if (s == "")
{
s = id;
}
else
{
s = s + "," + id;
}
}
strWhere = strWhere + " AND A.idx IN (" + s + ")";
}
else
{
strWhere = "1=1";
}
}
//else if ( _model.WZ001 != null )
//{
// strWhere = "1=1";
// strWhere = strWhere + " AND WZ001='" + _model.WZ001 + "'";
//}
button3_Click(null, null);
toolAdd.Enabled = toolDelete.Enabled = toolUpdate.Enabled = toolSelect.Enabled = toolReview.Enabled = toolPrint.Enabled = toolExport.Enabled = toolLibrary.Enabled = toolStorage.Enabled = toolMaintain.Enabled = toolcopy.Enabled = true;
toolSave.Enabled = toolCancel.Enabled = false;
}
void assignMent( )
{
_model = _bll.GetModel(_model.IDX);
if (_model.WZ002 > DateTime.MinValue && _model.WZ002 < DateTime.MaxValue)
{
dateTimePicker1.Value = _model.WZ002;
}
lookUpEdit1.Text = _model.WZ003;
textBox4.Text = _model.WZ004;
lookUpEdit2.Text = _model.WZ005;
textBox1.Text = _model.WZ006;
textBox3.Text = _model.WZ007;
textBox2.Text = _model.WZ008;
textBox5.Text = _model.WZ009;
textBox6.Text = _model.WZ010.ToString( );
textBox7.Text = _model.WZ011.ToString( );
textBox8.Text = _model.WZ012.ToString( );
textBox9.Text = _model.WZ013.ToString( );
textBox10.Text = _model.WZ014.ToString( );
textBox11.Text = _model.WZ015;
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.DetailedDeductionLibrary GetDataRow(DataRow row)
{
MulaolaoLibrary.DetailedDeductionLibrary _model = new MulaolaoLibrary.DetailedDeductionLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
_model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["WZ001"] != null && row["WZ001"].ToString( ) != "")
{
_model.WZ001 = row["WZ001"].ToString( );
}
if (row["WZ002"] != null && row["WZ002"].ToString( ) != "")
{
_model.WZ002 = DateTime.Parse(row["WZ002"].ToString( ));
}
if (row["WZ003"] != null && row["WZ003"].ToString( ) != "")
{
_model.WZ003 = row["WZ003"].ToString( );
}
if (row["WZ004"] != null && row["WZ004"].ToString( ) != "")
{
_model.WZ004 = row["WZ004"].ToString( );
}
if (row["WZ005"] != null && row["WZ005"].ToString( ) != "")
{
_model.WZ005 = row["WZ005"].ToString( );
}
if (row["WZ006"] != null && row["WZ006"].ToString( ) != "")
{
_model.WZ006 = row["WZ006"].ToString( );
}
if (row["WZ007"] != null && row["WZ007"].ToString( ) != "")
{
_model.WZ007 = row["WZ007"].ToString( );
}
if (row["WZ008"] != null && row["WZ008"].ToString( ) != "")
{
_model.WZ008 = row["WZ008"].ToString( );
}
if (row["WZ009"] != null && row["WZ009"].ToString( ) != "")
{
_model.WZ009 = row["WZ009"].ToString( );
}
if (row["WZ010"] != null && row["WZ010"].ToString( ) != "")
{
_model.WZ010 = decimal.Parse(row["WZ010"].ToString( ));
}
if (row["WZ011"] != null && row["WZ011"].ToString( ) != "")
{
_model.WZ011 = decimal.Parse(row["WZ011"].ToString( ));
}
if (row["WZ012"] != null && row["WZ012"].ToString( ) != "")
{
_model.WZ012 = decimal.Parse(row["WZ012"].ToString( ));
}
if (row["WZ013"] != null && row["WZ013"].ToString( ) != "")
{
_model.WZ013 = decimal.Parse(row["WZ013"].ToString( ));
}
if (row["WZ014"] != null && row["WZ014"].ToString( ) != "")
{
_model.WZ014 = decimal.Parse(row["WZ014"].ToString( ));
}
if (row["WZ015"] != null && row["WZ015"].ToString( ) != "")
{
_model.WZ015 = row["WZ015"].ToString( );
}
if (row["WZ016"] != null && row["WZ016"].ToString( ) != "")
{
_model.WZ016 = row["WZ016"].ToString( );
}
}
return(_model);
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.DetailedDeductionLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQWZ SET ");
strSql.Append("WZ002=@WZ002,");
strSql.Append("WZ003=@WZ003,");
strSql.Append("WZ004=@WZ004,");
strSql.Append("WZ005=@WZ005,");
strSql.Append("WZ006=@WZ006,");
strSql.Append("WZ007=@WZ007,");
strSql.Append("WZ008=@WZ008,");
strSql.Append("WZ009=@WZ009,");
strSql.Append("WZ010=@WZ010,");
strSql.Append("WZ011=@WZ011,");
strSql.Append("WZ012=@WZ012,");
strSql.Append("WZ013=@WZ013,");
strSql.Append("WZ014=@WZ014,");
strSql.Append("WZ015=@WZ015");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@WZ002", SqlDbType.Date),
new SqlParameter("@WZ003", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ004", SqlDbType.NVarChar, 50),
new SqlParameter("@WZ005", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ006", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ007", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ008", SqlDbType.NVarChar, 20),
new SqlParameter("@WZ009", SqlDbType.NVarChar, 50),
new SqlParameter("@WZ010", SqlDbType.Decimal),
new SqlParameter("@WZ011", SqlDbType.Decimal),
new SqlParameter("@WZ012", SqlDbType.Decimal),
new SqlParameter("@WZ013", SqlDbType.Decimal),
new SqlParameter("@WZ014", SqlDbType.Decimal),
new SqlParameter("@WZ015", SqlDbType.NVarChar, 100),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter[0].Value = _model.WZ002;
parameter[1].Value = _model.WZ003;
parameter[2].Value = _model.WZ004;
parameter[3].Value = _model.WZ005;
parameter[4].Value = _model.WZ006;
parameter[5].Value = _model.WZ007;
parameter[6].Value = _model.WZ008;
parameter[7].Value = _model.WZ009;
parameter[8].Value = _model.WZ010;
parameter[9].Value = _model.WZ011;
parameter[10].Value = _model.WZ012;
parameter[11].Value = _model.WZ013;
parameter[12].Value = _model.WZ014;
parameter[13].Value = _model.WZ015;
parameter[14].Value = _model.IDX;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.DetailedDeductionLibrary _model)
{
return(_dao.Edit(_model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.DetailedDeductionLibrary _model)
{
return(_dao.Add(_model));
}
