/// <summary>
/// 删除菜单
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public xt_result getShanchucaidan(caidan mCaidan)
{
string sql = " delete caidan where xuhao=@xuhao and yingyong=@yingyong;";
sql = sql + "delete gongneng where xuhao=@xuhao and yingyong=@yingyong;";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar),
new SqlParameter("@xuhao", SqlDbType.NVarChar) };
param[0].Value = mCaidan.Yingyong;
param[1].Value = mCaidan.Xuhao;
xt_result result = new xt_result();
result.Message = "删除 成功";
try
{
result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param);
if (result.ReturnInt < 1)
{
result.Message = "删除 失败";
}
}
catch (Exception e)
{
result.Message = e.Message;
result.Message = result.Message.Replace("\r\n", "\\n");
result.Message = result.Message.Replace("'", "");
}
return(result);
}
/// <summary>
/// 插入菜单
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public xt_result getCharucaidan(caidan mCaidan, string pDaihao)
{
string sql = "insert into caidan(yingyong,bianhao,xuhao,fuxuhao,mingcheng,jiancheng,url,image) values(@yingyong,@bianhao,@xuhao,@fuxuhao,@mingcheng,@jiancheng,@url,@image);";
sql = sql + "insert into gongneng(daihao,yingyong,bianhao,xuhao,mingcheng,canshu0,canshu1,canshu2,canshu3,canshu4,canshu5,canshu6,canshu7,canshu8,canshu9)values( @pDaihao,@yingyong,@bianhao,@xuhao,@mingcheng,'0','0','0','0','0','0','0','0','0','0')";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar),
new SqlParameter("@bianhao", SqlDbType.NVarChar),
new SqlParameter("@xuhao", SqlDbType.NVarChar),
new SqlParameter("@fuxuhao", SqlDbType.VarChar),
new SqlParameter("@mingcheng", SqlDbType.VarChar),
new SqlParameter("@jiancheng", SqlDbType.VarChar),
new SqlParameter("@url", SqlDbType.VarChar),
new SqlParameter("@image", SqlDbType.VarChar),
new SqlParameter("@pDaihao", SqlDbType.VarChar), };
param[0].Value = mCaidan.Yingyong;
param[1].Value = mCaidan.Bianhao;
param[2].Value = mCaidan.Xuhao;
param[3].Value = mCaidan.Fuxuhao;
param[4].Value = mCaidan.Mingcheng;
param[5].Value = mCaidan.Jiancheng;
param[6].Value = mCaidan.Url;
param[7].Value = mCaidan.Image;
param[8].Value = pDaihao;
xt_result result = new xt_result();
result.Message = "插入 成功";
try
{
result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param);
if (result.ReturnInt < 1)
{
result.Message = "插入 失败";
}
}
catch (Exception e)
{
result.Message = e.Message;
result.Message = result.Message.Replace("\r\n", "\\n");
result.Message = result.Message.Replace("'", "");
}
return(result);
}
/// <summary>
/// 更新菜单
/// </summary>
/// <param name="mCaidan"></param>
/// <returns></returns>
public xt_result getGengaicaidan(caidan mCaidan)
{
string sql = "update caidan set yingyong=@yingyong,xuhao=@xuhao,fuxuhao=@fuxuhao,mingcheng=@mingcheng,jiancheng=@jiancheng,url=@url,image=@image where bianhao=@bianhao ";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar),
new SqlParameter("@bianhao", SqlDbType.NVarChar),
new SqlParameter("@xuhao", SqlDbType.NVarChar),
new SqlParameter("@fuxuhao", SqlDbType.VarChar),
new SqlParameter("@mingcheng", SqlDbType.VarChar),
new SqlParameter("@jiancheng", SqlDbType.VarChar),
new SqlParameter("@url", SqlDbType.VarChar),
new SqlParameter("@image", SqlDbType.VarChar), };
param[0].Value = mCaidan.Yingyong;
param[1].Value = mCaidan.Bianhao;
param[2].Value = mCaidan.Xuhao;
param[3].Value = mCaidan.Fuxuhao;
param[4].Value = mCaidan.Mingcheng;
param[5].Value = mCaidan.Jiancheng;
param[6].Value = mCaidan.Url;
param[7].Value = mCaidan.Image;
//开始事务
xt_result result = new xt_result();
result.Message = "更新 成功";
try
{
result.ReturnInt = SQLHelper.ExecuteNonQuery(base.User_Login, CommandType.Text, sql, param);
if (result.ReturnInt < 1)
{
result.Message = "更新 失败";
}
}
catch (Exception e)
{
result.Message = e.Message;
result.Message = result.Message.Replace("\r\n", "\\n");
result.Message = result.Message.Replace("'", "");
}
return(result);
}
/// <summary>
/// 更新菜单
/// </summary>
/// <param name="mCaidan"></param>
/// <returns></returns>
public xt_result getGengaicaidan(caidan mCaidan)
{
return(dCaidan.getGengaicaidan(mCaidan));
}
/// <summary>
/// 删除菜单
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public xt_result getShanchucaidan(caidan mCaidan)
{
return(dCaidan.getShanchucaidan(mCaidan));
}
/// <summary>
/// 插入菜单
/// </summary>
/// <param name="mCaidan"></param>
/// <returns></returns>
public xt_result getCharucaidan(caidan mCaidan, string pDaihao)
{
return(dCaidan.getCharucaidan(mCaidan, pDaihao));
}
