/// <summary>
/// 新增数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_DBB (DBB001,DBB002,DBB003,DBB004,DBB005,DBB006,DBB007,DBB008,DBB009,DBB010,DBB011,DBB012,DBB013,DBB014,DBB015,DBB016,DBB017) ");
strSql.Append("VALUES (@DBB001,@DBB002,@DBB003,@DBB004,@DBB005,@DBB006,@DBB007,@DBB008,@DBB009,@DBB010,@DBB011,@DBB012,@DBB013,@DBB014,@DBB015,@DBB016,@DBB017)");
SqlParameter [] parameter =
{
new SqlParameter("@DBB001", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB002", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB003", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB004", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB005", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB006", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB007", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB008", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB009", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB010", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB011", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB012", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB013", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB014", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB015", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB016", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB017", SqlDbType.NVarChar, 20)
};
parameter [0].Value = _model.DBB001;
parameter [1].Value = _model.DBB002;
parameter [2].Value = _model.DBB003;
parameter [3].Value = _model.DBB004;
parameter [4].Value = _model.DBB005;
parameter [5].Value = _model.DBB006;
parameter [6].Value = _model.DBB007;
parameter [7].Value = _model.DBB008;
parameter [8].Value = _model.DBB009;
parameter [9].Value = _model.DBB010;
parameter [10].Value = _model.DBB011;
parameter [11].Value = _model.DBB012;
parameter [12].Value = _model.DBB013;
parameter [13].Value = _model.DBB014;
parameter [14].Value = _model.DBB015;
parameter [15].Value = _model.DBB016;
parameter [16].Value = _model.DBB017;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public Power(Form fm)
{
this.MdiParent = fm;
InitializeComponent( );
_model = new MulaolaoLibrary.PowerEntity( );
_bll = new MulaolaoBll.Bll.PowerBll( );
GridViewMoHuSelect.SetFilter(searchLookUpEdit1View);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { this.gvPower });
MulaolaoBll.UserInfoMation.tableName = this.Name;
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("DELETE FROM R_DBB WHERE DBB001='{0}' AND DBB002='{1}'", _model.DBB001, _model.DBB002);
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ));
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_DBB SET ");
strSql.Append("DBB003=@DBB003,");
strSql.Append("DBB004=@DBB004,");
strSql.Append("DBB005=@DBB005,");
strSql.Append("DBB006=@DBB006,");
strSql.Append("DBB007=@DBB007,");
strSql.Append("DBB008=@DBB008,");
strSql.Append("DBB009=@DBB009,");
strSql.Append("DBB010=@DBB010,");
strSql.Append("DBB011=@DBB011,");
strSql.Append("DBB012=@DBB012,");
strSql.Append("DBB013=@DBB013,");
strSql.Append("DBB014=@DBB014,");
strSql.Append("DBB015=@DBB015,");
strSql.Append("DBB016=@DBB016,");
strSql.Append("DBB017=@DBB017 ");
strSql.Append("WHERE DBB001=@DBB001 AND ");
strSql.Append("DBB002=@DBB002");
SqlParameter [] parameter =
{
new SqlParameter("@DBB001", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB002", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB003", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB004", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB005", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB006", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB007", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB008", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB009", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB010", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB011", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB012", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB013", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB014", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB015", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB016", SqlDbType.NVarChar, 20),
new SqlParameter("@DBB017", SqlDbType.NVarChar, 20)
};
parameter [0].Value = _model.DBB001;
parameter [1].Value = _model.DBB002;
parameter [2].Value = _model.DBB003;
parameter [3].Value = _model.DBB004;
parameter [4].Value = _model.DBB005;
parameter [5].Value = _model.DBB006;
parameter [6].Value = _model.DBB007;
parameter [7].Value = _model.DBB008;
parameter [8].Value = _model.DBB009;
parameter [9].Value = _model.DBB010;
parameter [10].Value = _model.DBB011;
parameter [11].Value = _model.DBB012;
parameter [12].Value = _model.DBB013;
parameter [13].Value = _model.DBB014;
parameter [14].Value = _model.DBB015;
parameter [15].Value = _model.DBB016;
parameter [16].Value = _model.DBB017;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.PowerEntity _model)
{
return(_dal.Delete(_model));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.PowerEntity _model)
{
return(_dal.Edit(_model));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.PowerEntity _model)
{
return(_dal.Insert(_model));
}
