/// <summary>
/// 录入处理结果，以及客户满意度，服务归档
/// </summary>
public static int SaveCSResult(string csResult, int csSatisfy, int csID)
{
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@CSResult", csResult),
new SqlParameter("@CSSatisfy", csSatisfy),
new SqlParameter("@CSID", csID)
};
return(BaseDAL.ExecuteNonQuery("update CustomServices set CSResult=@CSResult,CSSatisfy=@CSSatisfy,CSState=4 where CSID=@CSID", pars));
}
/// <summary>
/// 录入服务处理，等待客户回应
/// </summary>
public static int SaveCSDeal(string csDeal, int csID)
{
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@CSDeal", csDeal),
new SqlParameter("@CSDealDate", DateTime.Now),
new SqlParameter("@CSID", csID)
};
return(BaseDAL.ExecuteNonQuery("update CustomServices set CSDeal=@CSDeal,CSDealDate=@CSDealDate,CSState=3 where CSID=@CSID", pars));
}
/// <summary>
/// 更新权限
/// </summary>
public static bool UpdatePowers(int rid, int[] Powers)
{
try
{
//先删除原有权限
BaseDAL.ExecuteNonQuery("delete Power where RoleID=" + rid);
//添加新的权限
foreach (var item in Powers)
{
if (Convert.ToInt32(BaseDAL.ExecuteScalar("select count(*) from Power where RoleID=" + rid + " and MenuID=" + item)) == 0)
{
BaseDAL.ExecuteNonQuery("insert into Power (RoleID, MenuID) values (" + rid + ", " + item + ")");
}
}
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 客户流失
/// </summary>
public static int CusLost(int cusID)
{
return(BaseDAL.ExecuteNonQuery("update Customers set CusState=2 where CusID=" + cusID));
}
/// <summary>
/// 更改状态为暂缓
/// </summary>
public static int UpdateStateTo2(int clID)
{
return(BaseDAL.ExecuteNonQuery("update CustomLosts set CLState=2 where CLID=" + clID));
}
/// <summary>
/// 检查流失报警
/// </summary>
private static void Lost()
{
BaseDAL.ExecuteNonQuery("exec p_lost");
}
