/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KPS.Model.PermissionInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PSI_Permission set ");
strSql.Append("userName=@userName,");
strSql.Append("moduleInfoID=@moduleInfoID");
strSql.Append(" where permissionID=@permissionID");
OleDbParameter[] parameters =
{
new OleDbParameter("@userName", OleDbType.VarChar, 255),
new OleDbParameter("@moduleInfoID", OleDbType.Integer, 4),
new OleDbParameter("@permissionID", OleDbType.Integer, 4)
};
parameters[0].Value = model.userName;
parameters[1].Value = model.moduleInfoID;
parameters[2].Value = model.permissionID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KPS.Model.PermissionInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PSI_Permission(");
strSql.Append("userName,moduleInfoID)");
strSql.Append(" values (");
strSql.Append("@userName,@moduleInfoID)");
OleDbParameter[] parameters =
{
new OleDbParameter("@userName", OleDbType.VarChar, 255),
new OleDbParameter("@moduleInfoID", OleDbType.Integer, 4)
};
parameters[0].Value = model.userName;
parameters[1].Value = model.moduleInfoID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KPS.Model.PermissionInfo DataRowToModel(DataRow row)
{
KPS.Model.PermissionInfo model = new KPS.Model.PermissionInfo();
if (row != null)
{
if(row["permissionID"]!=null && row["permissionID"].ToString()!="")
{
model.permissionID=int.Parse(row["permissionID"].ToString());
}
if(row["userName"]!=null)
{
model.userName=row["userName"].ToString();
}
if(row["moduleInfoID"]!=null && row["moduleInfoID"].ToString()!="")
{
model.moduleInfoID=int.Parse(row["moduleInfoID"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KPS.Model.PermissionInfo DataRowToModel(DataRow row)
{
KPS.Model.PermissionInfo model = new KPS.Model.PermissionInfo();
if (row != null)
{
if (row["permissionID"] != null && row["permissionID"].ToString() != "")
{
model.permissionID = int.Parse(row["permissionID"].ToString());
}
if (row["userName"] != null)
{
model.userName = row["userName"].ToString();
}
if (row["moduleInfoID"] != null && row["moduleInfoID"].ToString() != "")
{
model.moduleInfoID = int.Parse(row["moduleInfoID"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KPS.Model.PermissionInfo GetModel(int permissionID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select permissionID,userName,moduleInfoID from PSI_Permission ");
strSql.Append(" where permissionID=@permissionID");
OleDbParameter[] parameters =
{
new OleDbParameter("@permissionID", OleDbType.Integer, 4)
};
parameters[0].Value = permissionID;
KPS.Model.PermissionInfo model = new KPS.Model.PermissionInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KPS.Model.PermissionInfo GetModel(int permissionID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select permissionID,userName,moduleInfoID from PSI_Permission ");
strSql.Append(" where permissionID=@permissionID");
OleDbParameter[] parameters = {
new OleDbParameter("@permissionID", OleDbType.Integer,4)
};
parameters[0].Value = permissionID;
KPS.Model.PermissionInfo model = new KPS.Model.PermissionInfo();
DataSet ds=DbHelperOleDb.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 菜单
/// </summary>
/// <param name="_Pinfo"></param>
private void MenuEnableTrue(KPS.Model.PermissionInfo _Pinfo)
{
switch (_Pinfo.moduleInfoID)
{
case 1:
InsertDataMenu1.Enabled = true;
btnBuyInsert.Enabled = true;
break;
case 2:
XSDataMenu1.Enabled = true;
break;
case 3:
InsertDataMenu2.Enabled = true;
break;
case 4:
InsertDataMenu3.Enabled = true;
btnSellInsert.Enabled = true;
break;
case 5:
InsertDataMenu9.Enabled = true;
break;
case 6:
ToolStripMenuItemSH.Enabled = true;
break;
case 7:
ToolStripMenuItemBHGPJL.Enabled = true;
break;
case 8:
toolStripMenuItem1.Enabled = true;
break;
case 9:
toolStripMenuItem2.Enabled = true;
break;
case 10:
HeadDataQueryMenu_CPCG.Enabled = true;
btnBuyQuery.Enabled = true;
break;
case 11:
HeadDataQueryMenu_CPSC.Enabled = true;
break;
case 12:
HeadDataQueryMenu_CPTH.Enabled = true;
break;
case 13:
HeadDataQueryMenu_CPHH.Enabled = true;
btnSellQuery.Enabled = true;
break;
case 14:
toolStripMenuItem5.Enabled = true;
break;
case 15:
toolStripMenuItem4.Enabled = true;
break;
case 16:
toolStripMenuItem6.Enabled = true;
break;
case 17:
toolStripMenuItem3.Enabled = true;
break;
case 18:
HeadDataQueryMenu_Unqualified.Enabled = true;
break;
case 19:
HeadTolMenu_DBSetting.Enabled = true;
break;
case 20:
HeadTolMenu_User.Enabled = true;
break;
case 21:
HeadTolMenu_Modul.Enabled = true;
break;
case 22:
TolMenuItem_UpPwd.Enabled = true;
break;
case 23:
TolMenuData_ProName.Enabled = true;
break;
case 24:
TolMenuData_ProUnit.Enabled = true;
break;
case 25:
TolMenuData_ProM.Enabled = true;
break;
case 26:
TolMenuData_Supper.Enabled = true;
break;
case 27:
TolMenuDevice_Class.Enabled = true;
break;
case 28:
TolMenuItem_BackRev.Enabled = true;
break;
case 29:
HeadDataQueryMenu_Inventory.Enabled = true;
btnInventoryQuery.Enabled = true;
break;
case 30:
btnInventoryQueryTotal.Enabled = true;
break;
default:
break;
}
}
