private void GetTPage(out string msg)
{
msg = string.Empty;
int cid = -1;
if (int.TryParse(CID, out cid))
{
Entities.QueryTPage query = new Entities.QueryTPage();
query.SCID = cid;
query.Statuss = "1,2";
query.IsUsed = 1; //“是否可用”为启用
int totalCount = 0;
DataTable dt = BLL.TPage.Instance.GetTPage(query, "", 1, 1000, out totalCount);
string path = "/upload/" + BLL.Util.GetUploadProject(BLL.Util.ProjectTypePath.Template, "/");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
if (i == 0)
{
msg += "[{RecID:'" + dr["RecID"] + "',TPName:'" + dr["TPName"] + "','GenTempletPath':'" + path + dr["GenTempletPath"] + "','TTCode':'" + dr["TTCode"] + "'}";
}
if (i > 0)
{
msg += ",{RecID:'" + dr["RecID"] + "',TPName:'" + dr["TPName"] + "','GenTempletPath':'" + path + dr["GenTempletPath"] + "','TTCode':'" + dr["TTCode"] + "'}";
}
if (i == dt.Rows.Count - 1)
{
msg += "]";
}
}
}
}
/// <summary>
/// 获取IsShowBtn的值
/// </summary>
/// <param name="TTCode"></param>
/// <returns></returns>
private void IsShowBtnByTTCode(string TTCode, out string msg)
{
msg = string.Empty;
Entities.QueryTPage query = new Entities.QueryTPage();
query.TTCode = TTCode;
int totalCount = 0;
DataTable dt = BLL.TPage.Instance.GetTPage(query, "", 1, 1, out totalCount);
if (totalCount > 0)
{
if (dt.Rows[0]["IsShowBtn"].ToString() == "1")
{
msg = "'IsShowBtn':'true',";
}
if (dt.Rows[0]["IsShowWorkOrderBtn"].ToString() == "1")
{
msg += "'IsShowWorkOrderBtn':'true',";
}
if (dt.Rows[0]["IsShowSendMsgBtn"].ToString() == "1")
{
msg += "'IsShowSendMsgBtn':'true',";
}
if (dt.Rows[0]["IsShowQiCheTong"].ToString() == "1")
{
msg += "'IsShowQiCheTong':'true',";
}
if (dt.Rows[0]["IsShowSubmitOrder"].ToString() == "1")
{
msg += "'IsShowSubmitOrder':'true',";
}
}
if (msg == string.Empty)
{
msg = "{'result':'false'}";
}
else
{
msg = "{'result':'true'," + msg.TrimEnd(',') + "}";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && TTCode != "")
{
Entities.QueryTPage query = new Entities.QueryTPage();
query.TTCode = TTCode;
int totalCount = 0;
DataTable dt = BLL.TPage.Instance.GetTPage(query, "", 1, 999, out totalCount);
if (dt != null && dt.Rows.Count > 0)
{
TPageName = dt.Rows[0]["TPName"].ToString();
IsShowBtn = dt.Rows[0]["IsShowBtn"].ToString();
IsShowWorkOrderBtn = dt.Rows[0]["IsShowWorkOrderBtn"].ToString();
IsShowSendMsgBtn = dt.Rows[0]["IsShowSendMsgBtn"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int userId = BLL.Util.GetLoginUserID();
if (!BLL.Util.CheckRight(userId, "SYS024MOD510204") && !BLL.Util.CheckRight(userId, "SYS024MOD510205") && !BLL.Util.CheckRight(userId, "SYS024MOD5101"))
{
Response.Write(BLL.Util.GetNotAccessMsgPage("您没有访问该页面的权限"));
Response.End();
}
ALLNotEstablishReasonStr = CallResult_ORIG_Task.GetNotEstablishReasonStr();
ALLNotSuccessReasonStr = CallResult_ORIG_Task.GetNotSuccessReasonStr();
if (!IsPostBack && TTCode != "")
{
Entities.QueryTPage query = new Entities.QueryTPage();
query.TTCode = TTCode;
int totalCount = 0;
DataTable dt = BLL.TPage.Instance.GetTPage(query, "", 1, 999, out totalCount);
if (dt != null && dt.Rows.Count > 0)
{
TPageName = dt.Rows[0]["TPName"].ToString();
BGID = dt.Rows[0]["BGID"].ToString();
CID = dt.Rows[0]["SCID"].ToString();
Desc = dt.Rows[0]["TPContent"].ToString();
IsShowBtn = dt.Rows[0]["IsShowBtn"].ToString();
IsShowWorkOrderBtn = dt.Rows[0]["IsShowWorkOrderBtn"].ToString();
IsShowSendMsgBtn = dt.Rows[0]["IsShowSendMsgBtn"].ToString();
IsShowQiCheTong = dt.Rows[0]["IsShowQiCheTong"].ToString();
IsShowSubmitOrder = dt.Rows[0]["IsShowSubmitOrder"].ToString();
templateStatus = BLL.TPage.Instance.getStatus(dt.Rows[0]["RecID"].ToString(), dt.Rows[0]["Status"].ToString()).ToString();
}
}
}
private void CheckMsg(TemplateInfo tempInfoData, out string msg)
{
msg = "";
int intVal = 0;
if (tempInfoData.templateName == "")
{
msg += "模板名称不能为空<br>";
}
if (tempInfoData.BGID == "" || tempInfoData.BGID == "-1")
{
msg += "模板所属分组不能为空<br>";
}
if (!int.TryParse(tempInfoData.BGID, out intVal))
{
msg += "模板所属业务分组ID格式不正确";
}
if (tempInfoData.CID == "" || tempInfoData.CID == "-1")
{
msg += "模板分类不能为空<br>";
}
if (!int.TryParse(tempInfoData.BGID, out intVal))
{
msg += "模板分类ID格式不正确";
}
if (tempInfoData.fieldListInfo != null)
{
for (int i = 0; i <= tempInfoData.fieldListInfo.Length - 1; i++)
{
#region 验证字段
if (tempInfoData.fieldListInfo[i].TFInportIsNull == "")
{
msg += "字段是否导入必填不能为空<br>";
}
if (!int.TryParse(tempInfoData.fieldListInfo[i].TFInportIsNull, out intVal) || (intVal != 0 && intVal != 1))
{
msg += "字段是否导入必填格式不正确";
}
if (tempInfoData.fieldListInfo[i].TFIsNull == "")
{
msg += "字段是否必填不能为空<br>";
}
if (!int.TryParse(tempInfoData.fieldListInfo[i].TFIsNull, out intVal) || (intVal != 0 && intVal != 1))
{
msg += "字段是否必填格式不正确";
}
if (tempInfoData.fieldListInfo[i].TFSortIndex == "")
{
msg += "字段排序索引不能为空<br>";
}
if (!int.TryParse(tempInfoData.fieldListInfo[i].TFSortIndex, out intVal) || (intVal <= 0))
{
msg += "字段排序索引格式不正确<br>";
}
//添加系统内置字段名称限制,与系统字段重复，不能添加
if ((tempInfoData.fieldListInfo[i].TFDesName == "操作时间") ||
(tempInfoData.fieldListInfo[i].TFDesName == "操作人") ||
(tempInfoData.fieldListInfo[i].TFDesName == "推荐活动" && tempInfoData.fieldListInfo[i].TFShowCode != "100019") ||
(tempInfoData.fieldListInfo[i].TFDesName == "是否成功" && tempInfoData.fieldListInfo[i].TFShowCode != "100020") ||
(tempInfoData.fieldListInfo[i].TFDesName == "是否接通" && tempInfoData.fieldListInfo[i].TFShowCode != "100020") ||
(tempInfoData.fieldListInfo[i].TFDesName == "失败原因" && tempInfoData.fieldListInfo[i].TFShowCode != "100020") ||
(tempInfoData.fieldListInfo[i].TFDesName == "未接通原因" && tempInfoData.fieldListInfo[i].TFShowCode != "100020") ||
tempInfoData.fieldListInfo[i].TFDesName == "任务ID" ||
(tempInfoData.fieldListInfo[i].TFDesName == "客户ID" && tempInfoData.fieldListInfo[i].TFShowCode != "100014") ||
tempInfoData.fieldListInfo[i].TFDesName == "任务状态"
)
{
msg += "【" + tempInfoData.fieldListInfo[i].TFDesName + "】字段名与系统字段重复，不能添加！<br>";
}
#endregion
#region 判断字段名不能重复
for (int j = i + 1; j <= tempInfoData.fieldListInfo.Length - 1; j++)
{
if (tempInfoData.fieldListInfo[j].TFDesName == tempInfoData.fieldListInfo[i].TFDesName)
{
msg += "【" + tempInfoData.fieldListInfo[j].TFDesName + "】字段名已经重复！<br>";
break;
}
}
#endregion
}
}
#region 判断模板名不能重复
if (tempInfoData.ttcode == "")
{
Entities.QueryTPage query = new Entities.QueryTPage();
query.TPName = tempInfoData.templateName;
int totalCount = 0;
DataTable dt = BLL.TPage.Instance.GetTPage(query, "", 1, 999, out totalCount);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["TPName"].ToString().Trim() == tempInfoData.templateName)
{
msg += "已经存在名为[" + tempInfoData.templateName + "]的模板";
break;
}
}
}
}
#endregion
}
//绑定数据
public void BindData()
{
Entities.QueryTPage query = new Entities.QueryTPage();
if (RequestName != "")
{
query.TPName = StringHelper.SqlFilter(RequestName);
}
if (RequestStatuss != "")
{
query.Statuss = StringHelper.SqlFilter(RequestStatuss);
}
if (RequestGroup != "")
{
query.BGID = int.Parse(RequestGroup);
}
if (RequestCategory != "")
{
query.SCID = int.Parse(RequestCategory);
}
if (RequestCreater != "")
{
query.CreateUserID = int.Parse(RequestCreater);
}
if (RequestBeginTime != "")
{
query.BeginTime = StringHelper.SqlFilter(RequestBeginTime);
}
if (RequestEndTime != "")
{
query.EndTime = StringHelper.SqlFilter(RequestEndTime);
}
query.LoginID = BLL.Util.GetLoginUserID();
//判断数据权限，数据权限如果为 2-全部，则查看所有数据
//Entities.UserDataRigth model_userDataRight = BLL.UserDataRigth.Instance.GetUserDataRigth(userID);
//if (model_userDataRight != null)
//{
// if (model_userDataRight.RightType != 2)//数据权限不为 2-全部
// {
// query.LoginID = userID;
// //判断分组权限，如果权限是2-本组，则能看到本组人创建的信息；如果权限是1-本人，则只能看本人创建的信息
// DataTable dt_userGroupDataRight = BLL.UserGroupDataRigth.Instance.GetUserGroupDataRigthByUserID(userID);
// string ownGroup = string.Empty;//权限是本组的 组串
// string oneSelf = string.Empty; //权限是本人的 组串
// for (int i = 0; i < dt_userGroupDataRight.Rows.Count; i++)
// {
// if (dt_userGroupDataRight.Rows[i]["RightType"].ToString() == "2")
// {
// ownGroup += dt_userGroupDataRight.Rows[i]["BGID"].ToString() + ",";
// }
// if (dt_userGroupDataRight.Rows[i]["RightType"].ToString() == "1")
// {
// oneSelf += dt_userGroupDataRight.Rows[i]["BGID"].ToString() + ",";
// }
// }
// query.OwnGroup = ownGroup.TrimEnd(',');
// query.OneSelf = oneSelf.TrimEnd(',');
// }
//}
int RecordCount = 0;
DataTable dt = BLL.TPage.Instance.GetTPage(query, "CreateTime Desc", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
