public FormUserInfo( )
{
InitializeComponent( );
_model = new MulaolaoLibrary.UserInfoEntity( );
_bll = new MulaolaoBll.Bll.UserInfoBll( );
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
toolReview.Text = "注销";
MulaolaoBll.UserInfoMation.tableName = this.Name;
UnEnable( );
}
/// <summary>
/// 编辑用户
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.UserInfoEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE TPADBA SET ");
strSql.Append("DBA002=@DBA002,");
strSql.Append("DBA005=@DBA005,");
strSql.Append("DBA006=@DBA006,");
strSql.Append("DBA028=@DBA028,");
strSql.Append("DBA960=@DBA960 ");
strSql.Append(" WHERE DBA001=@DBA001");
SqlParameter [] parameter =
{
new SqlParameter("@DBA001", SqlDbType.NVarChar),
new SqlParameter("@DBA002", SqlDbType.NVarChar),
new SqlParameter("@DBA005", SqlDbType.NVarChar),
new SqlParameter("@DBA006", SqlDbType.NVarChar),
new SqlParameter("@DBA028", SqlDbType.NVarChar),
new SqlParameter("@DBA960", SqlDbType.NVarChar)
};
parameter [0].Value = _model.DBA001;
parameter [1].Value = _model.DBA002;
parameter [2].Value = _model.DBA005;
parameter [3].Value = _model.DBA006;
parameter [4].Value = _model.DBA028;
parameter [5].Value = _model.DBA960;
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 Save(MulaolaoLibrary.UserInfoEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO TPADBA (");
strSql.Append("DBA001,DBA002,DBA005,DBA006,DBA028,DBA043,DBA960) ");
strSql.Append("VALUES (");
strSql.Append("@DBA001,@DBA002,@DBA005,@DBA006,@DBA028,@DBA043,@DBA960) ");
SqlParameter [] parameter =
{
new SqlParameter("@DBA001", SqlDbType.NVarChar),
new SqlParameter("@DBA002", SqlDbType.NVarChar),
new SqlParameter("@DBA005", SqlDbType.NVarChar),
new SqlParameter("@DBA006", SqlDbType.NVarChar),
new SqlParameter("@DBA028", SqlDbType.NVarChar),
new SqlParameter("@DBA043", SqlDbType.NVarChar),
new SqlParameter("@DBA960", SqlDbType.NVarChar)
};
parameter [0].Value = _model.DBA001;
parameter [1].Value = _model.DBA002;
parameter [2].Value = _model.DBA005;
parameter [3].Value = _model.DBA006;
parameter [4].Value = _model.DBA028;
parameter [5].Value = _model.DBA043;
parameter [6].Value = _model.DBA960;
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 Edit(MulaolaoLibrary.UserInfoEntity _model)
{
return(dao.Edit(_model));
}
/// <summary>
/// 保存用户
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.UserInfoEntity _model)
{
return(dao.Save(_model));
}