public static void UpdateKPITemplet(KPITempletInfo kpiTemplet)
{
dal.UpdateKPITemplet(kpiTemplet);
if (kpiTemplet.CompanyId == 0)
{
CacheHelper.Remove(cacheKey);
}
}
public static int AddKPITemplet(KPITempletInfo kpiTemplet)
{
kpiTemplet.ID = dal.AddKPITemplet(kpiTemplet);
if (kpiTemplet.CompanyId == 0)
{
CacheHelper.Remove(cacheKey);
}
return(kpiTemplet.ID);
}
protected override void PostBack()
{
IsPost = RequestHelper.GetForm <int>("IsPostCheck");
WorkingPost.CompanyId = RequestHelper.GetForm <int>("CompanyID");
if (WorkingPost.CompanyId < 0)
{
WorkingPost.CompanyId = base.UserCompanyID;
}
WorkingPost.ParentId = RequestHelper.GetForm <int>("ParentId");
WorkingPost.PostName = StringHelper.AddSafe(RequestHelper.GetForm <string>("PostName"));
WorkingPost.ID = WorkPostID;
WorkingPost.IsPost = IsPost;
if (WorkingPost.IsPost == 1)
{
KPIContent = RequestHelper.GetForm <string>("kpiidstr");
WorkingPost.KPITempletId = KPITempletBLL.ExistsKPITemplet(0, KPIContent);
if (WorkingPost.KPITempletId == 0)
{
KPITempletInfo kpiTemplet = new KPITempletInfo();
kpiTemplet.KPIContent = KPIContent;
kpiTemplet.CompanyId = WorkingPost.CompanyId;
WorkingPost.KPITempletId = KPITempletBLL.AddKPITemplet(kpiTemplet);
}
}
else
{
WorkingPost.IsPost = 0;
}
string alertMessage = ShopLanguage.ReadLanguage("AddOK");
if (WorkPostID == int.MinValue)
{
base.CheckUserPower("AddWorkingPost", PowerCheckType.Single);
int id = WorkingPostBLL.AddWorkingPost(WorkingPost);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("WorkingPost"), id);
}
else
{
base.CheckUserPower("UpdateWorkingPost", PowerCheckType.Single);
WorkingPostBLL.UpdateWorkingPost(WorkingPost);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("WorkingPost"), WorkPostID);
alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
}
string returnURL = ServerHelper.UrlDecode(RequestHelper.GetQueryString <string>("ReturnURL"));
if (string.IsNullOrEmpty(returnURL))
{
ScriptHelper.Alert(alertMessage, "WorkingPostAdd.aspx?CompanyID=" + WorkingPost.CompanyId.ToString());
}
else
{
ScriptHelper.Alert(alertMessage, returnURL);
}
}
public static List <KPITempletInfo> ReadSystemKPITempletList()
{
if (CacheHelper.Read(cacheKey) == null)
{
KPITempletInfo kpiTemplet = new KPITempletInfo();
kpiTemplet.CompanyId = 0;
CacheHelper.Write(cacheKey, SearchKPITempletList(kpiTemplet));
}
return((List <KPITempletInfo>)CacheHelper.Read(cacheKey));
}
public List <KPITempletInfo> SearchKPITempletList(KPITempletInfo kpiTemplet)
{
MssqlCondition mssqlCondition = new MssqlCondition();
this.PrepareCondition(mssqlCondition, kpiTemplet);
List <KPITempletInfo> kpiTempletList = new List <KPITempletInfo>();
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) };
pt[0].Value = mssqlCondition.ToString();
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchKPITempletList", pt))
{
this.PrepareModel(dr, kpiTempletList);
}
return(kpiTempletList);
}
public int AddKPITemplet(KPITempletInfo kpiTemplet)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@postId", SqlDbType.Int),
new SqlParameter("@kpiContent", SqlDbType.NVarChar),
new SqlParameter("@companyId", SqlDbType.NVarChar),
new SqlParameter("@state", SqlDbType.Float)
};
pt[0].Value = kpiTemplet.PostId;
pt[1].Value = kpiTemplet.KPIContent;
pt[2].Value = kpiTemplet.CompanyId;
pt[3].Value = kpiTemplet.State;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddKPITemplet", pt)));
}
public void PrepareModel(SqlDataReader dr, List <KPITempletInfo> kpiTempletList)
{
while (dr.Read())
{
KPITempletInfo info = new KPITempletInfo();
{
info.ID = int.Parse(dr["ID"].ToString());
info.PostId = int.Parse(dr["PostId"].ToString());
info.KPIContent = dr["KPIContent"].ToString();
info.CompanyId = int.Parse(dr["CompanyId"].ToString());
info.State = int.Parse(dr["State"].ToString());
}
kpiTempletList.Add(info);
}
}
public void UpdateKPITemplet(KPITempletInfo kpiTemplet)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@postId", SqlDbType.NVarChar),
new SqlParameter("@kpiContent", SqlDbType.Int),
new SqlParameter("@companyId", SqlDbType.NVarChar),
new SqlParameter("@state", SqlDbType.NVarChar)
};
pt[0].Value = kpiTemplet.ID;
pt[1].Value = kpiTemplet.PostId;
pt[2].Value = kpiTemplet.KPIContent;
pt[3].Value = kpiTemplet.CompanyId;
pt[4].Value = kpiTemplet.State;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateKPITemplet", pt);
}
public KPITempletInfo ReadKPITemplet(int id)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar) };
pt[0].Value = id;
KPITempletInfo info = new KPITempletInfo();
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadKPITemplet", pt))
{
if (dr.Read())
{
info.ID = int.Parse(dr["ID"].ToString());
info.PostId = int.Parse(dr["PostId"].ToString());
info.KPIContent = dr["KPIContent"].ToString();
info.CompanyId = int.Parse(dr["CompanyId"].ToString());
info.State = int.Parse(dr["State"].ToString());
}
}
return(info);
}
public void PrepareCondition(MssqlCondition mssqlCondition, KPITempletInfo kpiTemplet)
{
//mssqlCondition.Add("[ParentID]", kpiTemplet.ParentId, ConditionType.In);
//mssqlCondition.Add("[Name]", kpiTemplet.Name, ConditionType.Like);
mssqlCondition.Add("[CompanyId]", kpiTemplet.CompanyId, ConditionType.Equal);
}
public static List <KPITempletInfo> SearchKPITempletList(KPITempletInfo kpiTemplet)
{
return(dal.SearchKPITempletList(kpiTemplet));
}
