public PowerEdit(string text, CarpenterEntity.PowerEntity _model, string nameOfPerson, string nameOfProgram, string sign)
{
InitializeComponent( );
this.Text = text;
this.sign = sign;
this._model = _model;
this.nameOfPerson = nameOfPerson;
this.nameOfProgram = nameOfProgram;
if (sign.Equals("edit"))
{
lupNamePerson.Enabled = lupNamePro.Enabled = false;
}
else
{
lupNamePerson.Enabled = lupNamePro.Enabled = true;
}
lupNamePerson.Properties.DataSource = _bll.GetPerson( );
lupNamePerson.Properties.DisplayMember = "DBA002";
lupNamePerson.Properties.ValueMember = "DBA001";
lupNamePro.Properties.DataSource = _bll.GetProgram( );
lupNamePro.Properties.DisplayMember = "FOR001";
lupNamePro.Properties.ValueMember = "FOR002";
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int EditIdx(CarpenterEntity.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT idx FROM MOXPOW ");
strSql.Append("WHERE POW002=@POW002 AND POW003=@POW003");
SqlParameter [] parameter =
{
new SqlParameter("@POW002", SqlDbType.NVarChar, 20),
new SqlParameter("@POW003", SqlDbType.NVarChar, 20)
};
parameter [0].Value = _model.POW002;
parameter [1].Value = _model.POW003;
DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ), parameter);
if (da != null && da.Rows.Count > 0)
{
if (string.IsNullOrEmpty(da.Rows [0] ["idx"].ToString( )))
{
return(0);
}
else
{
return(int.Parse(da.Rows [0] ["idx"].ToString( )));
}
}
else
{
return(0);
}
}
public FormPower( )
{
InitializeComponent( );
_bll = new CarpenterBll.Bll.PowerBll( );
_model = new CarpenterEntity.PowerEntity( );
Utility.GridViewMoHuSelect.SetFilter(gridView1);
FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic);
fi.SetValue(null, new DrawXPaint( ));
barMenu.LinksPersistInfo.RemoveAt(toolExport.Id);
barMenu.LinksPersistInfo.RemoveAt(toolPrint.Id);
barMenu.LinksPersistInfo.RemoveAt(toolCancel.Id);
barMenu.LinksPersistInfo.RemoveAt(toolSave.Id);
lupPerson.Properties.DataSource = _bll.GetPerson( );
lupPerson.Properties.DisplayMember = "DBA002";
lupPerson.Properties.ValueMember = "DBA001";
lupProgram.Properties.DataSource = _bll.GetProgram( );
lupProgram.Properties.DisplayMember = "FOR001";
lupProgram.Properties.ValueMember = "FOR002";
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exsits(CarpenterEntity.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) COUN FROM MOXPOW ");
strSql.Append("WHERE POW002=@POW002 AND POW003=@POW003");
SqlParameter [] parameter =
{
new SqlParameter("@POW002", SqlDbType.NVarChar, 20),
new SqlParameter("@POW003", SqlDbType.NVarChar, 20)
};
parameter [0].Value = _model.POW002;
parameter [1].Value = _model.POW003;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(CarpenterEntity.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO MOXPOW (");
strSql.Append("POW002,POW003,POW004,POW005,POW006,POW007,POW008,POW009,POW010,POW011,POW012,POW013,POW016,POW017) ");
strSql.Append("VALUES (");
strSql.Append("@POW002,@POW003,@POW004,@POW005,@POW006,@POW007,@POW008,@POW009,@POW010,@POW011,@POW012,@POW013,@POW016,@POW017);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter [] parameter =
{
new SqlParameter("@POW002", SqlDbType.NVarChar, 20),
new SqlParameter("@POW003", SqlDbType.NVarChar, 50),
new SqlParameter("@POW004", SqlDbType.Bit),
new SqlParameter("@POW005", SqlDbType.Bit),
new SqlParameter("@POW006", SqlDbType.Bit),
new SqlParameter("@POW007", SqlDbType.Bit),
new SqlParameter("@POW008", SqlDbType.Bit),
new SqlParameter("@POW009", SqlDbType.Bit),
new SqlParameter("@POW010", SqlDbType.Bit),
new SqlParameter("@POW011", SqlDbType.Bit),
new SqlParameter("@POW012", SqlDbType.Bit),
new SqlParameter("@POW013", SqlDbType.Bit),
new SqlParameter("@POW016", SqlDbType.Bit),
new SqlParameter("@POW017", SqlDbType.Bit)
};
parameter [0].Value = _model.POW002;
parameter [1].Value = _model.POW003;
parameter [2].Value = _model.POW004;
parameter [3].Value = _model.POW005;
parameter [4].Value = _model.POW006;
parameter [5].Value = _model.POW007;
parameter [6].Value = _model.POW008;
parameter [7].Value = _model.POW009;
parameter [8].Value = _model.POW010;
parameter [9].Value = _model.POW011;
parameter [10].Value = _model.POW012;
parameter [11].Value = _model.POW013;
parameter [12].Value = _model.POW016;
parameter [13].Value = _model.POW017;
return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(CarpenterEntity.PowerEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MOXPOW SET ");
strSql.Append("POW002=@POW002,");
strSql.Append("POW003=@POW003,");
strSql.Append("POW004=@POW004,");
strSql.Append("POW005=@POW005,");
strSql.Append("POW006=@POW006,");
strSql.Append("POW007=@POW007,");
strSql.Append("POW008=@POW008,");
strSql.Append("POW009=@POW009,");
strSql.Append("POW010=@POW010,");
strSql.Append("POW011=@POW011,");
strSql.Append("POW012=@POW012,");
strSql.Append("POW013=@POW013,");
strSql.Append("POW016=@POW016,");
strSql.Append("POW017=@POW017 ");
strSql.Append("WHERE idx=@idx");
SqlParameter [] parameter =
{
new SqlParameter("@POW002", SqlDbType.NVarChar, 20),
new SqlParameter("@POW003", SqlDbType.NVarChar, 50),
new SqlParameter("@POW004", SqlDbType.Bit),
new SqlParameter("@POW005", SqlDbType.Bit),
new SqlParameter("@POW006", SqlDbType.Bit),
new SqlParameter("@POW007", SqlDbType.Bit),
new SqlParameter("@POW008", SqlDbType.Bit),
new SqlParameter("@POW009", SqlDbType.Bit),
new SqlParameter("@POW010", SqlDbType.Bit),
new SqlParameter("@POW011", SqlDbType.Bit),
new SqlParameter("@POW012", SqlDbType.Bit),
new SqlParameter("@POW013", SqlDbType.Bit),
new SqlParameter("@POW016", SqlDbType.Bit),
new SqlParameter("@POW017", SqlDbType.Bit),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter [0].Value = _model.POW002;
parameter [1].Value = _model.POW003;
parameter [2].Value = _model.POW004;
parameter [3].Value = _model.POW005;
parameter [4].Value = _model.POW006;
parameter [5].Value = _model.POW007;
parameter [6].Value = _model.POW008;
parameter [7].Value = _model.POW009;
parameter [8].Value = _model.POW010;
parameter [9].Value = _model.POW011;
parameter [10].Value = _model.POW012;
parameter [11].Value = _model.POW013;
parameter [12].Value = _model.POW016;
parameter [13].Value = _model.POW017;
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 int EditIdx(CarpenterEntity.PowerEntity _model)
{
return(_dao.EditIdx(_model));
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exsits(CarpenterEntity.PowerEntity _model)
{
return(_dao.Exsits(_model));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Edit(CarpenterEntity.PowerEntity _model)
{
return(_dao.Edit(_model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(CarpenterEntity.PowerEntity _model)
{
return(_dao.Add(_model));
}
