/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQBE WHERE BE002=@BE002 AND BE007=@BE007 AND BE008=@BE008 AND BE009=@BE009 AND BE010=@BE010 AND BE011=@BE011 AND BE012=@BE012 AND BE016=@BE016");
SqlParameter [] parameter =
{
new SqlParameter("@BE002", SqlDbType.NVarChar, 20),
new SqlParameter("@BE007", SqlDbType.Decimal, 11),
new SqlParameter("@BE008", SqlDbType.Decimal, 11),
new SqlParameter("@BE009", SqlDbType.Decimal, 11),
new SqlParameter("@BE010", SqlDbType.Decimal, 11),
new SqlParameter("@BE011", SqlDbType.Decimal, 11),
new SqlParameter("@BE012", SqlDbType.Decimal, 11),
new SqlParameter("@BE016", SqlDbType.NVarChar, 20)
};
parameter [0].Value = _model.BE002;
parameter [1].Value = _model.BE007;
parameter [2].Value = _model.BE008;
parameter [3].Value = _model.BE009;
parameter [4].Value = _model.BE010;
parameter [5].Value = _model.BE011;
parameter [6].Value = _model.BE012;
parameter [7].Value = _model.BE016;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
protected override void select( )
{
base.select( );
_model = new MulaolaoLibrary.OtherExpenseStatementLibrary( );
SelectAll.OtherExpenseStatementAll query = new SelectAll.OtherExpenseStatementAll( );
if (query.ShowDialog( ) == DialogResult.OK)
{
_model.BE015 = query.getOdd;
idxList = query.getAdd;
autoQuery( );
}
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Insert(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQBE (");
strSql.Append("BE001,BE002,BE003,BE004,BE005,BE006,BE007,BE008,BE009,BE010,BE011,BE012,BE015,BE016,BE017)");
strSql.Append(" VALUES (");
strSql.Append("@BE001,@BE002,@BE003,@BE004,@BE005,@BE006,@BE007,@BE008,@BE009,@BE010,@BE011,@BE012,@BE015,@BE016,@BE017);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter [] parameter =
{
new SqlParameter("@BE001", SqlDbType.NVarChar, 20),
new SqlParameter("@BE002", SqlDbType.NVarChar, 20),
new SqlParameter("@BE003", SqlDbType.NVarChar, 20),
new SqlParameter("@BE004", SqlDbType.NVarChar, 20),
new SqlParameter("@BE005", SqlDbType.Int),
new SqlParameter("@BE006", SqlDbType.NVarChar, 20),
new SqlParameter("@BE007", SqlDbType.Decimal, 11),
new SqlParameter("@BE008", SqlDbType.Decimal, 11),
new SqlParameter("@BE009", SqlDbType.Decimal, 11),
new SqlParameter("@BE010", SqlDbType.Decimal, 11),
new SqlParameter("@BE011", SqlDbType.Decimal, 11),
new SqlParameter("@BE012", SqlDbType.Decimal, 11),
new SqlParameter("@BE015", SqlDbType.NVarChar, 20),
new SqlParameter("@BE016", SqlDbType.NVarChar, 20),
new SqlParameter("@BE017", SqlDbType.NVarChar, 200)
};
parameter [0].Value = _model.BE001;
parameter [1].Value = _model.BE002;
parameter [2].Value = _model.BE003;
parameter [3].Value = _model.BE004;
parameter [4].Value = _model.BE005;
parameter [5].Value = _model.BE006;
parameter [6].Value = _model.BE007;
parameter [7].Value = _model.BE008;
parameter [8].Value = _model.BE009;
parameter [9].Value = _model.BE010;
parameter [10].Value = _model.BE011;
parameter [11].Value = _model.BE012;
parameter [12].Value = _model.BE015;
parameter [13].Value = _model.BE016;
parameter [14].Value = _model.BE017;
return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter));
}
void build(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
row["BE001"] = _model.BE001;
row["BE002"] = _model.BE002;
row["BE003"] = _model.BE003;
row["BE004"] = _model.BE004;
row["BE005"] = _model.BE005;
row["BE006"] = _model.BE006;
row["BE007"] = _model.BE007;
row["BE008"] = _model.BE008;
row["BE009"] = _model.BE009;
row["BE010"] = _model.BE010;
row["BE011"] = _model.BE011;
row["BE012"] = _model.BE012;
row["BE015"] = _model.BE015;
row["BE016"] = _model.BE016;
row["DGA003"] = comboBox1.Text;
}
void assignMent( )
{
_model = _bll.GetDataTable(_model.idx);
if (_model == null)
{
return;
}
textBox1.Text = _model.BE001;
textBox2.Text = _model.BE002;
textBox3.Text = _model.BE003;
textBox4.Text = _model.BE004;
textBox5.Text = _model.BE005.ToString( );
textBox12.Text = _model.BE006;
textBox6.Text = _model.BE007.ToString( );
textBox7.Text = _model.BE008.ToString( );
textBox8.Text = _model.BE009.ToString( );
textBox9.Text = _model.BE010.ToString( );
textBox10.Text = _model.BE011.ToString( );
textBox11.Text = _model.BE012.ToString( );
textBox13.Text = _model.BE017;
changeIndex( );
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.OtherExpenseStatementLibrary GetModel(DataRow row)
{
MulaolaoLibrary.OtherExpenseStatementLibrary model = new MulaolaoLibrary.OtherExpenseStatementLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
model.idx = int.Parse(row["idx"].ToString( ));
}
if (row["BE001"] != null && row["BE001"].ToString( ) != "")
{
model.BE001 = row["BE001"].ToString( );
}
if (row["BE002"] != null && row["BE002"].ToString( ) != "")
{
model.BE002 = row["BE002"].ToString( );
}
if (row["BE003"] != null && row["BE003"].ToString( ) != "")
{
model.BE003 = row["BE003"].ToString( );
}
if (row["BE004"] != null && row["BE004"].ToString( ) != "")
{
model.BE004 = row["BE004"].ToString( );
}
if (row["BE005"] != null && row["BE005"].ToString( ) != "")
{
model.BE005 = int.Parse(row["BE005"].ToString( ));
}
if (row["BE006"] != null && row["BE006"].ToString( ) != "")
{
model.BE006 = row["BE006"].ToString( );
}
if (row["BE007"] != null && row["BE007"].ToString( ) != "")
{
model.BE007 = decimal.Parse(row["BE007"].ToString( ));
}
if (row["BE008"] != null && row["BE008"].ToString( ) != "")
{
model.BE008 = decimal.Parse(row["BE008"].ToString( ));
}
if (row["BE009"] != null && row["BE009"].ToString( ) != "")
{
model.BE009 = decimal.Parse(row["BE009"].ToString( ));
}
if (row["BE010"] != null && row["BE010"].ToString( ) != "")
{
model.BE010 = decimal.Parse(row["BE010"].ToString( ));
}
if (row["BE011"] != null && row["BE011"].ToString( ) != "")
{
model.BE011 = decimal.Parse(row["BE011"].ToString( ));
}
if (row["BE012"] != null && row["BE012"].ToString( ) != "")
{
model.BE012 = decimal.Parse(row["BE012"].ToString( ));
}
if (row["BE015"] != null && row["BE015"].ToString( ) != "")
{
model.BE015 = row["BE015"].ToString( );
}
if (row["BE016"] != null && row["BE016"].ToString( ) != "")
{
model.BE016 = row["BE016"].ToString( );
}
if (row ["BE017"] != null && row ["BE017"].ToString( ) != "")
{
model.BE017 = row ["BE017"].ToString( );
}
}
return(model);
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQBE SET ");
strSql.Append("BE002=@BE002,");
strSql.Append("BE003=@BE003,");
strSql.Append("BE004=@BE004,");
strSql.Append("BE005=@BE005,");
strSql.Append("BE006=@BE006,");
strSql.Append("BE007=@BE007,");
strSql.Append("BE008=@BE008,");
strSql.Append("BE009=@BE009,");
strSql.Append("BE010=@BE010,");
strSql.Append("BE011=@BE011,");
strSql.Append("BE012=@BE012,");
strSql.Append("BE001=@BE001,");
strSql.Append("BE016=@BE016,");
strSql.Append("BE017=@BE017 ");
strSql.Append(" WHERE idx=@idx");
SqlParameter [] parameter =
{
new SqlParameter("@BE002", SqlDbType.NVarChar, 20),
new SqlParameter("@BE003", SqlDbType.NVarChar, 20),
new SqlParameter("@BE004", SqlDbType.NVarChar, 20),
new SqlParameter("@BE005", SqlDbType.Int),
new SqlParameter("@BE006", SqlDbType.NVarChar, 20),
new SqlParameter("@BE007", SqlDbType.Decimal, 11),
new SqlParameter("@BE008", SqlDbType.Decimal, 11),
new SqlParameter("@BE009", SqlDbType.Decimal, 11),
new SqlParameter("@BE010", SqlDbType.Decimal, 11),
new SqlParameter("@BE011", SqlDbType.Decimal, 11),
new SqlParameter("@BE012", SqlDbType.Decimal, 11),
new SqlParameter("@BE001", SqlDbType.NVarChar, 20),
new SqlParameter("@BE016", SqlDbType.NVarChar, 20),
new SqlParameter("@BE017", SqlDbType.NVarChar, 200),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter [0].Value = _model.BE002;
parameter [1].Value = _model.BE003;
parameter [2].Value = _model.BE004;
parameter [3].Value = _model.BE005;
parameter [4].Value = _model.BE006;
parameter [5].Value = _model.BE007;
parameter [6].Value = _model.BE008;
parameter [7].Value = _model.BE009;
parameter [8].Value = _model.BE010;
parameter [9].Value = _model.BE011;
parameter [10].Value = _model.BE012;
parameter [11].Value = _model.BE001;
parameter [12].Value = _model.BE016;
parameter [13].Value = _model.BE017;
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 Update(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
return(_dao.Update(_model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Insert(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
return(_dao.Insert(_model));
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.OtherExpenseStatementLibrary _model)
{
return(_dao.Exists(_model));
}
