/// <summary>
/// 删除桌面项
/// </summary>
public bool DeleteDesk(BaseDeskTable deskTable)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from BASE_DESK ");
strSql.Append(" where COMPANY_CODE=@COMPANY_CODE and USER_CODE=@USER_CODE and FORM_NAME=@FORM_NAME and FORM_TITLE=@FORM_TITLE");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@USER_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@FORM_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@FORM_TITLE", SqlDbType.VarChar, 50),
new SqlParameter("@FORM_ARGS", SqlDbType.VarChar, 50)
};
parameters[0].Value = deskTable.COMPANY_CODE;
parameters[1].Value = deskTable.USER_CODE;
parameters[2].Value = deskTable.FORM_NAME;
parameters[3].Value = deskTable.FORM_TITLE;
parameters[4].Value = deskTable.FORM_ARGS;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 用户权限变更后我的桌面重置处理
/// </summary>
public void ReSetMyDesk(string companyCode, string userCode, string rolesCode)
{
//当前角色的所有权限
DataTable rolesDt = GetRoles(rolesCode).Tables[0];
//当前用户的桌面
DataTable deskDt = GetDeskDatas(companyCode, userCode).Tables[0];
foreach (DataRow deskRow in deskDt.Rows)
{
bool isExist = false;
foreach (DataRow rolesRow in rolesDt.Rows)
{
if (CConvert.ToString(deskRow["FORM_NAME"]).Equals(CConvert.ToString(rolesRow["CLASS_NAME"])) && CConvert.ToString(deskRow["FORM_ARGS"]).Equals(CConvert.ToString(rolesRow["TAG"])))
{
isExist = true;
}
}
if (!isExist)
{
//删除当前桌面应用
BaseDeskTable deskTable = new BaseDeskTable();
deskTable.COMPANY_CODE = CConvert.ToString(deskRow["COMPANY_CODE"]);
deskTable.USER_CODE = CConvert.ToString(deskRow["USER_CODE"]);
deskTable.FORM_NAME = CConvert.ToString(deskRow["FORM_NAME"]);
deskTable.FORM_TITLE = CConvert.ToString(deskRow["FORM_TITLE"]);
deskTable.FORM_ARGS = CConvert.ToString(deskRow["FORM_ARGS"]);
DeleteDesk(deskTable);
}
}
}
/// <summary>
/// 添加到桌面
/// </summary>
public bool InsertDesk(BaseDeskTable deskTable)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_DESK(");
strSql.Append("COMPANY_CODE,USER_CODE,FORM_NAME,FORM_TITLE,PIC,FORM_ARGS)");
strSql.Append(" values (");
strSql.Append("@COMPANY_CODE,@USER_CODE,@FORM_NAME,@FORM_TITLE,@PIC,@FORM_ARGS)");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@USER_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@FORM_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@FORM_TITLE", SqlDbType.VarChar, 50),
new SqlParameter("@PIC", SqlDbType.Image),
new SqlParameter("@FORM_ARGS", SqlDbType.VarChar, 50)
};
parameters[0].Value = deskTable.COMPANY_CODE;
parameters[1].Value = deskTable.USER_CODE;
parameters[2].Value = deskTable.FORM_NAME;
parameters[3].Value = deskTable.FORM_TITLE;
parameters[4].Value = deskTable.PIC;
parameters[5].Value = deskTable.FORM_ARGS;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 从我的桌面删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuDeskDelete_Click(object sender, EventArgs e)
{
Control[] control = this.Controls.Find(_pic.Name.Replace("Frm", "LBL") + CConvert.ToString(_pic.Tag, 2), true);
BaseDeskTable deskTable = new BaseDeskTable();
deskTable.COMPANY_CODE = UserTable.COMPANY_CODE;
deskTable.USER_CODE = UserTable.CODE;
deskTable.FORM_NAME = _pic.Name.Replace("Frm", "");
deskTable.FORM_TITLE = control[0].Text;
deskTable.FORM_ARGS = _pic.Tag.ToString();
//删除
if (bCommon.DeleteDesk(deskTable))
{
CCacheData.ResetDesk(UserTable.COMPANY_CODE, UserTable.CODE);
//页面刷新
ChildShowForm(this.Text, "menuDesk");
}
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(BaseDeskTable deskTable)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from BASE_DESK");
strSql.Append(" where COMPANY_CODE=@COMPANY_CODE and USER_CODE=@USER_CODE and FORM_NAME=@FORM_NAME and FORM_TITLE=@FORM_TITLE and FORM_ARGS=@FORM_ARGS ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@USER_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@FORM_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@FORM_TITLE", SqlDbType.VarChar, 50),
new SqlParameter("@FORM_ARGS", SqlDbType.VarChar, 50)
};
parameters[0].Value = deskTable.COMPANY_CODE;
parameters[1].Value = deskTable.USER_CODE;
parameters[2].Value = deskTable.FORM_NAME;
parameters[3].Value = deskTable.FORM_TITLE;
parameters[4].Value = deskTable.FORM_ARGS;
return(DbHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 添加到我的桌面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuDeskAdd_Click(object sender, EventArgs e)
{
Control[] control = this.Controls.Find(_pic.Name.Replace("Frm", "LBL") + CConvert.ToString(_pic.Tag, 2), true);
BaseDeskTable deskTable = new BaseDeskTable();
deskTable.COMPANY_CODE = UserTable.COMPANY_CODE;
deskTable.USER_CODE = UserTable.CODE;
deskTable.FORM_NAME = _pic.Name.Replace("Frm", "");
deskTable.FORM_TITLE = control[0].Text;
deskTable.FORM_ARGS = _pic.Tag.ToString();
deskTable.PIC = ImageToByte(_pic.Image);
try
{
DataTable dt = CCacheData.GetDesk(UserTable.COMPANY_CODE, UserTable.CODE);
if (dt != null && dt.Rows.Count > maxSize)
{
MessageBox.Show("我的桌面己经超出最大上限 " + maxSize, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
catch (Exception ex)
{
}
if (bCommon.Exists(deskTable))
{
MessageBox.Show(deskTable.FORM_TITLE + "己经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//添加
if (bCommon.InsertDesk(deskTable))
{
CCacheData.ResetDesk(UserTable.COMPANY_CODE, UserTable.CODE);
}
}
public bool DeleteDesk(BaseDeskTable deskTable)
{
return(dal.DeleteDesk(deskTable));
}
public bool InsertDesk(BaseDeskTable deskTable)
{
return(dal.InsertDesk(deskTable));
}
public bool Exists(BaseDeskTable deskTable)
{
return(dal.Exists(deskTable));
}
