protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
if (Request.QueryString["Type"] == "1")
{
//编辑保存
zlzw.Model.JobKindListModel jobKindListModel = new zlzw.Model.JobKindListModel();
jobKindListModel.JobKindName = txbNJobKindName.Text;
jobKindListModel.JobKindGUID = new Guid(ViewState["JobKindGUID"].ToString());
jobKindListModel.JobCategoryGUID = new Guid(drpJobCategory.SelectedValue);
jobKindListModel.IsEnable = 1;
if (ckbIsHot.Checked)
{
jobKindListModel.IsHot = 1;
}
else
{
jobKindListModel.IsHot = 0;
}
if (ckbIsShowDefaultPage.Checked)
{
jobKindListModel.IsShowDefaultPage = 1;
}
else
{
jobKindListModel.IsShowDefaultPage = 0;
}
jobKindListModel.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString());
jobKindListModel.JobKindID = int.Parse(Get_JobKindID(Request.QueryString["value"]));
zlzw.BLL.JobKindListBLL jobKindListBLL = new zlzw.BLL.JobKindListBLL();
jobKindListBLL.Update(jobKindListModel);
}
else
{
//添加保存
zlzw.Model.JobKindListModel jobKindListModel = new zlzw.Model.JobKindListModel();
jobKindListModel.JobKindName = txbNJobKindName.Text;
jobKindListModel.JobKindGUID = Guid.NewGuid();
jobKindListModel.JobCategoryGUID = new Guid(drpJobCategory.SelectedValue);
jobKindListModel.IsEnable = 1;
if (ckbIsHot.Checked)
{
jobKindListModel.IsHot = 1;
}
else
{
jobKindListModel.IsHot = 0;
}
if (ckbIsShowDefaultPage.Checked)
{
jobKindListModel.IsShowDefaultPage = 1;
}
else
{
jobKindListModel.IsShowDefaultPage = 0;
}
jobKindListModel.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
zlzw.BLL.JobKindListBLL jobKindListBLL = new zlzw.BLL.JobKindListBLL();
jobKindListBLL.Add(jobKindListModel);
}
// 2. Close this window and Refresh parent window
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
/// <summary>
/// 关闭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonClose_Click(object sender, EventArgs e)
{
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
try
{
// 1. 这里放置保存窗体中数据的逻辑
string sql;
string reqFlag = "0";
string strExpect_Time = "";
if (rbtnSecond.Checked)
{
reqFlag = "1";
}
else if (rbtnFirst.Checked)
{
reqFlag = "2";
}
sql = "INSERT INTO bug_main_info (bug_title,bug_type,sub_bug_count) ";
sql += "VALUES ('" + BugTitle.Text + "', " + BugType.SelectedItem.Value + ", 1 ) ";
//Alert.ShowInTop(sql);
int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
if (rst != 1)
{
Alert.ShowInTop("save error！");
}
string sIsResolved = "0";
if (IsResolved.Checked)
{
sIsResolved = "1";
}
sql = "select IDENT_CURRENT('bug_main_info') ";
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
string newId = "0";
while (reader.Read())
{
newId = reader.GetValue(0).ToString();
}
string resolveUser = "******";
if (DropDownList1.SelectedItem != null)
{
resolveUser = DropDownList1.SelectedItem.Value;
}
sql = "INSERT INTO bug_detail_info (bug_id,process_type,is_resolved,phenomenon,create_time,occur_time,create_user_id,bug_state, ";
sql += "pj_id,PRI,rsolve_time,resolve_user_id,solution,cur_user_id,next_user_id,pd_id,req_flag,expect_time) ";
sql += "VALUES (" + newId + "," + BugProcType.SelectedItem.Value + "," + sIsResolved + ",'" + Phenomenon.Text + "',GETDATE(), ";
if (OccurTime.Text == "")
{
sql += "NULL, ";
}
else
{
sql += "cast('";
sql += OccurTime.SelectedDate;
sql += "' as datetime),";
}
// sql+="cast('" + OccurTime.SelectedDate + "' as datetime),";
sql += Page.Session["user_id"].ToString() + ",6001," + BugBelongPJ.SelectedItem.Value + "," + BugAuth.SelectedItem.Value + ", ";
if (FixTime.Text == "")
{
sql += "NULL, ";
}
else
{
sql += "cast('";
sql += FixTime.SelectedDate;
sql += "' as datetime),";
}
// sql += "cast('" + FixTime.SelectedDate + "' as datetime),";
sql += resolveUser + ",'" + Solution.Text + "'," + Page.Session["user_id"].ToString() + "," + NextUser.SelectedItem.Value;
sql += ", " + BugBelongPD.SelectedItem.Value + ", " + reqFlag + ", ";
if (Expect_Time.Text == "")
{
sql += "NULL";
}
else
{
sql += "cast('";
sql += Expect_Time.SelectedDate;
sql += "' as datetime)";
}
sql += ");";
// 2. 关闭本窗体，然后刷新父窗体
rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
if (rst != 1)
{
Alert.ShowInTop("save error !");
}
sql = "select IDENT_CURRENT('bug_detail_info') ";
reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
string newDetailId = "0";
while (reader.Read())
{
newDetailId = reader.GetValue(0).ToString();
}
AddBugRecord(newDetailId, "新增*预期解决日期:" + string.Format("{0:d}", Expect_Time.SelectedDate));
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
//发送邮件
// int res= Utils.SendEmail(Utils.GetEmail(NextUser.SelectedValue), Utils.GetEmail(Page.Session["user_id"].ToString()), BugTitle.Text, Phenomenon.Text);
//if (NextUser.SelectedValue !="0")
//{
// string Solution_1 = Solution.Text.Replace("\n", "<BR>               ");
// string Phenomenon_1 = Phenomenon.Text.Replace("\n", "<BR>           ");
// string Theme = "问题主题：" + BugTitle.Text + ", 提出人：" + Utils.GetUserName(Convert.ToInt32(Page.Session["user_id"].ToString())) + ", 问题状态：新增";
// string concent = "<BR>问题标题: " + BugTitle.Text + "<BR>提出人: " + Utils.GetUserName(Convert.ToInt32(Page.Session["user_id"].ToString())) + "<BR>所属项目: " + BugBelongPJ.SelectedText + "<BR>所属产品 " + BugBelongPD.SelectedText + "<BR>当前状态 " + "新增" + "<BR>现象描述: " + Phenomenon_1 + "<BR>现场处理过程: " + Solution_1 + "<BR><BR><BR><BR><BR><BR>                                 -----此邮件来自瑞驰管理系统";
// int res = Utils.SendEmail(Utils.GetEmail(NextUser.SelectedValue), Utils.GetEmail(Page.Session["user_id"].ToString()), Theme, concent);
// if (res != 0)
// {
// Alert.ShowInTop("邮件发送失败 请联系检查邮件地址是否为公司邮箱!");
// }
//}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
if (Request.QueryString["Type"] == "1")
{
//编辑保存
zlzw.Model.CareersListModal careersListModal = new zlzw.Model.CareersListModal();
careersListModal.DictionaryKey = drpStoreType.SelectedValue; //所属门店
careersListModal.DepartmentName = txbDepartmentName.Text; //招聘部门
careersListModal.CareersTitle = txbCareersTitle.Text; //职位名称
careersListModal.CareersCount = int.Parse(txbCareersCount.Text); //招聘人数
careersListModal.WorkAdd = txbWorkAdd.Text; //工作地点
careersListModal.Educational = txbEducational.Text; //学历要求
careersListModal.Salary = txbSalary.Text; //月薪
careersListModal.WorkExperience = txbWorkExperience.Text; //工作经验
careersListModal.EMail = txbEmail.Text; //联系邮件
careersListModal.Telephone = txbTel.Text; //联系电话
careersListModal.ContactMan = txbContactMan.Text; //联系人
careersListModal.Responsibilities = txbResponsibilities.Text; //岗位职责
careersListModal.Qualifications = txbQualifications.Text; //任职资格
if (ckbIsHot.Checked)
{
careersListModal.IsHot = 1;
}
else
{
careersListModal.IsHot = 0;
}
careersListModal.IsEnable = 1;
careersListModal.CareersGUID = new Guid(Request.QueryString["value"]);
careersListModal.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString());
careersListModal.CareersID = int.Parse(Get_CareersID(Request.QueryString["value"]));
zlzw.BLL.CareersListBLL careersListBLL = new zlzw.BLL.CareersListBLL();
careersListBLL.Update(careersListModal);
}
else
{
//添加保存
zlzw.Model.CareersListModal careersListModal = new zlzw.Model.CareersListModal();
careersListModal.DictionaryKey = drpStoreType.SelectedValue; //所属门店
careersListModal.DepartmentName = txbDepartmentName.Text; //招聘部门
careersListModal.CareersTitle = txbCareersTitle.Text; //职位名称
careersListModal.CareersCount = int.Parse(txbCareersCount.Text); //招聘人数
careersListModal.WorkAdd = txbWorkAdd.Text; //工作地点
careersListModal.Educational = txbEducational.Text; //学历要求
careersListModal.Salary = txbSalary.Text; //月薪
careersListModal.WorkExperience = txbWorkExperience.Text; //工作经验
careersListModal.EMail = txbEmail.Text; //联系邮件
careersListModal.Telephone = txbTel.Text; //联系电话
careersListModal.ContactMan = txbContactMan.Text; //联系人
careersListModal.Responsibilities = txbResponsibilities.Text; //岗位职责
careersListModal.Qualifications = txbQualifications.Text; //任职资格
careersListModal.CareersGUID = Guid.NewGuid(); //创建GUID
careersListModal.IsEnable = 1;
if (ckbIsHot.Checked)
{
careersListModal.IsHot = 1;
}
else
{
careersListModal.IsHot = 0;
}
careersListModal.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
zlzw.BLL.CareersListBLL careersListBLL = new zlzw.BLL.CareersListBLL();
careersListBLL.Add(careersListModal);
}
// 2. Close this window and Refresh parent window
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
this.SaveData(BLL.Const.BtnSave);
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
// 1. 这里放置保存窗体中数据的逻辑
string top_flag = "0";
if (CheckBox1.Checked)
{
top_flag = "1";
}
string sql = "";
string vals = Request.Url.Query;
if (vals == "")
{
sql = "INSERT INTO sys_organize_info ";
sql += "(org_name, org_normal_name, org_manager_name, org_assist_name, is_top, father_org_id) ";
sql += "VALUES ('" + TextBox5.Text + "', '" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + TextBox3.Text + "'," + top_flag + ", " + dr_dpt.SelectedItem.Value + ") ";
//Alert.ShowInTop(sql);
int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
if (rst != 1)
{
Alert.ShowInTop("save error！");
return;
}
sql = "select IDENT_CURRENT('sys_organize_info') ";
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
string newId = "0";
while (reader.Read())
{
newId = reader.GetValue(0).ToString();
}
sql = " insert into sys_func_authority (og_id,og_type)values ('";
sql += newId;
sql += "',3002)";
//Alert.ShowInTop(sql);
rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
if (rst < 0)
{
Alert.ShowInTop("save error！");
}
}
else
{
oid = Request.QueryString.GetValues(0)[0];
sql = "update sys_organize_info set org_name='" + TextBox5.Text + "',org_normal_name='" + TextBox1.Text + "',org_manager_name='" + TextBox2.Text;
sql += "',org_assist_name='" + TextBox3.Text + "',is_top=" + top_flag + ",father_org_id= " + dr_dpt.SelectedItem.Value;
sql += " where org_id = " + oid;
int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
if (rst != 1)
{
Alert.ShowInTop("save error !");
}
}
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
// 1. 这里放置保存窗体中数据的逻辑
int messageID = int.Parse(Request.QueryString["id"].Trim());
List <T_Message> message = messageBLL.GetMessageById(messageID);
T_Message messageModel = new T_Message();
try
{
#region 邮件信息
MailMessage mail = new MailMessage();
mail.To.Add(new MailAddress(message[0].Email));
mail.From = new MailAddress(txb_ReplyEmailAddress.Text.Trim(), "武汉理工大学心理健康平台", System.Text.Encoding.UTF8);
string _body = "";
string _subject = "回复：" + txa_BriefQuestion.Text.Trim();
_body = HtmlEditor1.Text + "<br/><br/>******************************************************" + "<br/>" +
"这是一封系统自动发送的邮件通知，请不要直接回复，如有疑问，请联系管理员。" + "<br/>" +
"<br/>请添加本邮箱为联系人，以便于即时收到邮件通知。祝 学习生活愉快！";
mail.Body = _body;
mail.Subject = _subject;
mail.Priority = MailPriority.High;
mail.IsBodyHtml = true;
//mail.BodyEncoding = System.Text.Encoding.UTF8;
#endregion
#region 发送方服务器信息
SmtpClient smtp = new SmtpClient();
if (txb_ReplyEmailAddress.Text.Trim().IndexOf("@126.com") >= 0)
{
smtp.Host = "smtp.126.com";
}
//smtp.UseDefaultCredentials = true;
//smtp.EnableSsl = true;
string mailFromAddress = txb_ReplyEmailAddress.Text.Split(new char[] { '@' })[0];
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", txb_ReplyEmailPwd.Text.Trim());
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Port = 25;
//smtp.Send(mail); //同步发送程序将被阻塞
#endregion
#region 异步发送邮件 判断发送状态
smtp.SendCompleted += new SendCompletedEventHandler(SendCompletedCallBack);
string userState = "测试";
smtp.SendAsync(mail, userState);
#endregion
}
catch
{
throw;
}
#region 保存至数据库
messageModel.ID = messageID;
messageModel.NickName = message[0].NickName;
messageModel.Sex = message[0].Sex;
messageModel.Email = message[0].Email;
messageModel.Grade = message[0].Grade;
messageModel.TeacherName = message[0].TeacherName;
messageModel.BriefQuestion = txa_BriefQuestion.Text.Trim();
messageModel.DetailQuestion = txa_DetailQuestion.Text.Trim();
messageModel.QuestionTime = message[0].QuestionTime;
messageModel.Reply = HtmlEditor1.Text.Trim();
messageModel.ReplyTime = DateTime.Now;
messageModel.Category = 0;
if (HtmlEditor1.Text.Trim() != "")
{
messageModel.Status = 1;
}
int result = messageBLL.Update(messageModel);
if (result > 0)
{
Alert alert = new Alert();
alert.Message = "回复成功";
alert.Target = Target.Top;
alert.Show();
}
else
{
Alert alert = new Alert();
alert.Message = "出现错误 请稍后再试";
alert.Target = Target.Top;
alert.Show();
}
#endregion
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
//新增
protected void btnSaveRefresh_Click2(object sender, EventArgs e)
{
try
{
// 1. 这里放置保存窗体中数据的逻辑
string sql = "";
string pjm_id = Request.QueryString.GetValues(1)[0];
sql += " INSERT INTO dev_sdd_mission_detail ";
sql += " (sdd_pjm_id,user_id,";
if (NumBox2.Text != "")
{
sql += "PAP,";
}
if (NumberBox1.Text != "")
{
sql += "rPAP,";
}
sql += "mission_content,expect_date,begin_date,finish_flag";
if (DatePicker3.Text != "")
{
sql += ",finish_date";
}
sql += ") ";
sql += " VALUES (" + pjm_id + "," + DropDownList7.SelectedItem.Value + ",";
if (NumBox2.Text != "")
{
sql += NumBox2.Text + ",";
}
if (NumberBox1.Text != "")
{
sql += NumberBox1.Text + ",";
}
sql += "'" + content.Text + "','" + DatePicker4.Text + "','" + DatePicker2.Text + "',";
string finishFlag = "0";
if (CheckBox1.Checked)
{
finishFlag = "1";
}
sql += finishFlag;
if (DatePicker3.Text != "")
{
sql += ",'" + DatePicker3.Text + "'";
}
sql += ");";
int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql);
if (rst != 1)
{
Alert.ShowInTop("save error !");
}
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
catch (System.Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnSaveClose_Click(object sender, EventArgs e)
{
//PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
int budgetID = GetQueryIntValue("id");
if (budgetID > 0)
{
Infobasis.Data.DataEntity.BudgetTemplate data = DB.BudgetTemplates
.Where(u => u.ID == budgetID).FirstOrDefault();
if (data == null)
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("参数错误！", String.Empty, ActiveWindow.GetHideReference());
return;
}
data.Code = tbxCode.Text.Trim();
data.Name = tbxName.Text;
data.DisplayOrder = Change.ToInt(tbxDisplayOrder.Text);
if (Change.ToInt(DropDownProvince.SelectedValue) > 0)
{
data.ProvinceID = Change.ToInt(DropDownProvince.SelectedValue);
data.ProvinceName = DropDownProvince.SelectedText;
}
if (Change.ToInt(DropDownBoxBudgetType.SelectedValue) > 0)
{
data.BudgetTypeID = Change.ToInt(DropDownBoxBudgetType.SelectedValue);
data.BudgetTypeName = DropDownBoxBudgetType.SelectedText;
}
data.IsActive = tbxIsActive.Checked;
data.BudgetTemplateStatus = tbxIsActive.Checked ? BudgetTemplateStatus.Enabled : BudgetTemplateStatus.Disabled;
data.LastUpdateDatetime = DateTime.Now;
data.Remark = tbxRemark.Text;
data.LastUpdateByID = UserInfo.Current.ID;
data.LastUpdateByName = UserInfo.Current.ChineseName;
}
else
{
Infobasis.Data.DataEntity.BudgetTemplate data = new Infobasis.Data.DataEntity.BudgetTemplate()
{
CreateDatetime = DateTime.Now,
Code = tbxCode.Text.Trim(),
Name = tbxName.Text,
Remark = tbxRemark.Text,
BudgetTemplateStatus = Infobasis.Data.DataEntity.BudgetTemplateStatus.Enabled
};
data.DisplayOrder = Change.ToInt(tbxDisplayOrder.Text);
if (Change.ToInt(DropDownProvince.SelectedValue) > 0)
{
data.ProvinceID = Change.ToInt(DropDownProvince.SelectedValue);
data.ProvinceName = DropDownProvince.SelectedText;
}
if (Change.ToInt(DropDownBoxBudgetType.SelectedValue) > 0)
{
data.BudgetTypeID = Change.ToInt(DropDownBoxBudgetType.SelectedValue);
data.BudgetTypeName = DropDownBoxBudgetType.Text;
}
data.IsActive = tbxIsActive.Checked;
data.BudgetTemplateStatus = tbxIsActive.Checked ? BudgetTemplateStatus.Enabled : BudgetTemplateStatus.Disabled;
DB.BudgetTemplates.Add(data);
}
SaveChanges();
ShowNotify("添加成功");
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
protected void PageManager1_CustomEvent(object sender, CustomEventArgs e)
{
string picurl = @"";
if (e.EventArgument.IndexOf("mysave") >= 0)
{
//获取上传的授权书图片并和授权书相关数据一起保存
JArray jaResult = JsonConvert.DeserializeObject <JArray>(hfdURL.Text);
foreach (JToken jt in jaResult)
{
picurl += jt["_raw"].ToString() + ",";
}
if (picurl.Length <= 0)
{
Alert.Show("请传入授权书证照图片！");
return;
}
picurl = picurl.Substring(0, picurl.Length - 1);
string[] arrays = picurl.Split(',');
StringBuilder sb = new StringBuilder();
for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++)
{
sb.Append(GridList.SelectedRowIndexArray[i].ToString() + ",");
}
sb = sb.Remove(sb.Length - 1, 1);
string seqnostr = hfdGrantid.Text;
List <CommandInfo> liscmd = new List <CommandInfo>();
string sqtype = "";
if (chkisLR.Checked)
{
sqtype = "厂家直接授权";
}
else
{
sqtype = "代理商授权";
}
DataTable dtt = DbHelperOra.Query(@"SELECT PRODUCER,F_GETSUPNAME(PRODUCER)PRODUCERNAME,SUPID,F_GETSUPNAME(SUPID)SUPNAME,SUPTOID,F_GETSUPNAME(SUPTOID)SUPTONAME,FLAG,SQREGION,BEGINSQRQ,ENDSQRQ,
DECODE(FLAG,'N','已保存','S','已提交','Y','已审批','R','已驳回') FLAGNAME,DOCID,SUPAGENT,GOODSINDEX,F_GETSUPNAME(SUPAGENT)SUPAGENTNAME,MEMO,SQTYPE FROM DOC_LICENSE_GRANT T WHERE GRANTID='" + hfdGrantid.Text + "' AND SUPTOID='" + hfdbesup.Text + "'").Tables[0];
string supid = dtt.Rows[0]["SUPID"].ToString(); //授权方
string producer = dtt.Rows[0]["PRODUCER"].ToString(); //生产厂商
string suptoid = dtt.Rows[0]["SUPTOID"].ToString(); //被授权方
string flag = dtt.Rows[0]["FLAG"].ToString(); //状态
if (flag.Equals("N") || flag.Equals("R"))
{
//如果证照是保存或撤回状态，直接删除掉已保存证照，再换上新证照
List <CommandInfo> delCmd = new List <CommandInfo>();
delCmd.Add(new CommandInfo("delete from doc_license_grant where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdbesup.Text + "' and iscur='Y'", null));
delCmd.Add(new CommandInfo("delete from doc_license_grantgoods where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null));
delCmd.Add(new CommandInfo("delete from doc_license_sqimg where seqno='" + hfdGrantid.Text + "' and str2='" + hfdbesup.Text + "' and iscur='Y'", null));
DbHelperOra.ExecuteSqlTran(delCmd);
}
else
{
//如果证照状态不是N或R的话，直接将现有证照变成老证照,ISCUR='N'（将状态直接变成N）
List <CommandInfo> liscommand = new List <CommandInfo>();
liscommand.Add(new CommandInfo("update doc_license_grant set iscur='N' where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdbesup.Text + "' and iscur='Y'", null));
liscommand.Add(new CommandInfo("update doc_license_grantgoods set iscur='N' where grantid='" + hfdGrantid.Text + "' and supbeto='" + hfdbesup.Text + "' and iscur='Y'", null));
liscommand.Add(new CommandInfo("update doc_license_sqimg SET ISCUR='N' where seqno='" + hfdGrantid.Text + "' and str2='" + hfdbesup.Text + "' and iscur='Y'", null));
DbHelperOra.ExecuteSqlTran(liscommand);
}
//换证之后，更新新录入的证照流水，其他老流水保持不变。插入本次换证的新证照
string seqnostrnew = DbHelperOra.GetSingle("SELECT SEQ_LICENSE_PIC.NEXTVAL FROM DUAL").ToString();
string myseq = "LIS" + producer + seqnostrnew;
for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++)
{
int rowIndex = GridList.SelectedRowIndexArray[i];
string gdseq = GridList.DataKeys[rowIndex][0].ToString();
string gdname = GridList.DataKeys[rowIndex][1].ToString();
string gdspec = GridList.DataKeys[rowIndex][2].ToString();
liscmd.Add(new CommandInfo(@"insert into doc_license_grantgoods(GRANTID,FLAG,GDSEQ,GDNAME,SPEC,SUPPLIER,UPTIME,SUPBETO,ISCUR)
values('" + myseq + "','N','" + gdseq + "','" + gdname + "','" + gdspec + "','" + producer + "',sysdate,'" + hfdbesup.Text + "','Y')", null));
}
if (sqtype.Equals("厂家直接授权"))
{
//如果是厂家直接授权，则生产商和授权方都是生产商
liscmd.Add(new CommandInfo(@"insert into doc_license_grant(GRANTID,PRODUCER,SUPID,SUPTOID,SUPAGENT,FLAG,SQREGION,BEGINSQRQ,ENDSQRQ,OPERTIME,LRY,MEMO,GOODSINDEX,DOCID,SQTYPE,ISCUR,ISCHANGE)
values('" + myseq + "','" + producer + "','" + supid + "','" + hfdbesup.Text + "','" + hfdagent.Text + "','N','" + tbxSQREGION.Text + "',to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SYSDATE,'" + UserAction.UserID + "','" + tbxMEMO.Text + "','" + sb.ToString() + "','" + tbxDOCID.Text + "','" + sqtype + "','Y','Y')", null));
}
else
{
//如果是代理商授权，则授权方是代理商
liscmd.Add(new CommandInfo(@"insert into doc_license_grant(GRANTID,PRODUCER,SUPID,SUPTOID,SUPAGENT,FLAG,SQREGION,BEGINSQRQ,ENDSQRQ,OPERTIME,LRY,MEMO,GOODSINDEX,DOCID,SQTYPE,ISCUR,ISCHANGE)
values('" + myseq + "','" + producer + "','" + hfdagent.Text + "','" + hfdbesup.Text + "','" + hfdagent.Text + "','N','" + tbxSQREGION.Text + "',to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SYSDATE,'" + UserAction.UserID + "','" + tbxMEMO.Text + "','" + sb.ToString() + "','" + tbxDOCID.Text + "','" + sqtype + "','Y','Y')", null));
}
//授权链中有一个换证，那么将整个层级授权的流水更改成换证后的新流水,并且将层级中其他证照一并更换流水及授权商品、状态
liscmd.Add(new CommandInfo("update doc_license_grant set grantid='" + myseq + "',flag='N',goodsindex='" + sb.ToString() + "' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null));
liscmd.Add(new CommandInfo("update doc_license_grantgoods set grantid='" + myseq + "',flag='N' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null));
liscmd.Add(new CommandInfo("update doc_license_sqimg set seqno='" + myseq + "' where seqno='" + hfdGrantid.Text + "' and iscur='Y'", null));
//换证更新首级代理商
DataTable chkddt = DbHelperOra.Query("select supid,suptoid from doc_license_grantdoc where grantid='" + hfdGrantid.Text + "'").Tables[0];
if (chkddt.Rows[0][0].ToString().Equals(hfdbesup.Text) && chkddt.Rows[0][1].ToString().Equals(hfdsupid.Text))
{
liscmd.Add(new CommandInfo("update doc_license_grantdoc set sqregion='" + tbxSQREGION.Text + "',beginsqrq=to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),endsqrq=to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),grantid='" + myseq + "',flag='N',ischange='Y',goodsindex='" + sb.ToString() + "' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null));
}
else
{
liscmd.Add(new CommandInfo("update doc_license_grantdoc set grantid='" + myseq + "',flag='N',ischange='Y' where grantid='" + hfdGrantid.Text + "' and iscur='Y'", null));
}
for (int i = 1; i < arrays.Length + 1; i++)
{
liscmd.Add(new CommandInfo(@"insert into DOC_LICENSE_SQIMG(SEQNO,ROWNO,IMGPATH,UPTTIME,LICENSEID,ISCUR,STR1,STR2)values('" + myseq + "','" + i + "','" + arrays[i - 1] + "',sysdate,'" + "SQ" + "','Y','" + producer + "','" + hfdbesup.Text + "')", null));
}
if (DbHelperOra.ExecuteSqlTran(liscmd))
{
Alert.Show("证照上传成功！");
flagLbl.Text = "当前状态:已保存";
//DataSearch();
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
else
{
Alert.Show("证照上传失败！");
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//非换证直接保存的情况
if (isChange.Text.Equals("N"))
{
string sqtype = "";
if (chkisLR.Checked)
{
sqtype = "厂家直接授权";
}
else
{
sqtype = "代理商授权";
}
DateTime beginsqrq = Convert.ToDateTime(dpkBEGRQ.Text);
DateTime endsqrq = Convert.ToDateTime(dpkENDRQ.Text);
List <CommandInfo> liscmd = new List <CommandInfo>();
string sb = string.Empty;
for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++)
{
sb = sb + GridList.SelectedRowIndexArray[i].ToString() + ",";
}
sb = sb.Remove(sb.Length - 1, 1);
if (!sb.Equals(hfdGoodsIndex.Text))
{
for (int i = 0; i < GridList.SelectedRowIndexArray.Length; i++)
{
int rowIndex = GridList.SelectedRowIndexArray[i];
string gdseq = GridList.DataKeys[rowIndex][0].ToString();
string gdname = GridList.DataKeys[rowIndex][1].ToString();
string gdspec = GridList.DataKeys[rowIndex][2].ToString();
liscmd.Add(new CommandInfo(@"insert into doc_license_grantgoods(GRANTID,FLAG,GDSEQ,GDNAME,SPEC,SUPPLIER,UPTIME,SUPBETO,ISCUR)
values('" + hfdGrantid.Text + "','N','" + gdseq + "','" + gdname + "','" + gdspec + "','" + trgPRODUCER.Text + "',sysdate,'" + hfdbesup.Text + "','Y')", null));
}
liscmd.Add(new CommandInfo("UPDATE DOC_LICENSE_GRANT SET FLAG='N',SQTYPE='" + sqtype + "',SUPAGENT='" + hfdagent.Text + "',SUPTOID='" + hfdbesup.Text + "',BEGINSQRQ=to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),ENDSQRQ=to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SQREGION='" + tbxSQREGION.Text + "',DOCID='" + tbxDOCID.Text + "',MEMO='" + tbxMEMO.Text + "',GOODSINDEX='" + sb.ToString() + "' where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdSuptoid.Text + "'", null));
}
else
{
liscmd.Add(new CommandInfo("UPDATE DOC_LICENSE_GRANT SET FLAG='N',SQTYPE='" + sqtype + "',SUPAGENT='" + hfdagent.Text + "',SUPTOID='" + hfdbesup.Text + "',BEGINSQRQ=to_date('" + dpkBEGRQ.Text + "','yyyy/mm/dd'),ENDSQRQ=to_date('" + dpkENDRQ.Text + "','yyyy/mm/dd'),SQREGION='" + tbxSQREGION.Text + "',DOCID='" + tbxDOCID.Text + "',MEMO='" + tbxMEMO.Text + "' where grantid='" + hfdGrantid.Text + "' and suptoid='" + hfdSuptoid.Text + "'", null));
}
if (DbHelperOra.ExecuteSqlTran(liscmd))
{
Alert.Show("保存成功！");
flagLbl1.Hidden = true;
flagLbl.Hidden = false;
flagLbl.Text = "当前状态:已保存";
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
else
{
Alert.Show("保存失败！");
}
}
else //执行换证操作后保存
{
if (dpkBEGRQ.Text.Length <= 0)
{
Alert.Show("请为 授权日期* 提供有效值！");
return;
}
if (dpkENDRQ.Text.Length <= 0)
{
Alert.Show("请为 截止日期* 提供有效值！");
return;
}
DateTime dtBEGRQ = Convert.ToDateTime(dpkBEGRQ.Text);
DateTime dtENDRQ = Convert.ToDateTime(dpkENDRQ.Text);
if (dtBEGRQ > dtENDRQ)
{
Alert.Show("授权日期不能大于截止日期！");
return;
}
if (GridList.SelectedRowIndexArray.Length <= 0)
{
Alert.Show("必须选择授权的商品！");
return;
}
PageContext.RegisterStartupScript("save();");
}
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
if (Request.QueryString["Type"] == "1")
{
//编辑保存
zlzw.Model.StorefrontEleganceListModal storefrontEleganceListModal = new zlzw.Model.StorefrontEleganceListModal();
storefrontEleganceListModal.StorefrontEleganceGUID = new Guid(ViewState["StorefrontEleganceGUID"].ToString()); //店面风采GUID
storefrontEleganceListModal.Other01 = drpRegionList.SelectedValue;
storefrontEleganceListModal.DictionaryKey = drpStorefrontEleganceType.SelectedValue; //所属门店
storefrontEleganceListModal.StorefrontEleganceTitle = txbStorefrontEleganceTitle.Text; //门店名称
storefrontEleganceListModal.StorefrontEleganceDescription = txbStorefrontEleganceDescription.Text; //门店简介
storefrontEleganceListModal.PushJobs = txbPushJobs.Text; //主推岗位
if (btnStorefrontEleganceHeadImage.PostedFile.ContentLength > 0)
{
btnStorefrontEleganceHeadImage.SaveAs(Server.MapPath(ViewState["StorefrontEleganceHeadImage"].ToString()));
storefrontEleganceListModal.StorefrontEleganceHeadImage = ViewState["StorefrontEleganceHeadImage"].ToString();//保存页面头部门店介绍路径
}
else
{
storefrontEleganceListModal.StorefrontEleganceHeadImage = ViewState["StorefrontEleganceHeadImage"].ToString();
}
storefrontEleganceListModal.IsEnable = 1;
storefrontEleganceListModal.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString());
storefrontEleganceListModal.StorefrontEleganceID = int.Parse(Get_StorefrontEleganceID(Request.QueryString["value"]));
storefrontEleganceListModal.StorefrontEleganceGUID = new Guid(Request.QueryString["value"]);
zlzw.BLL.StorefrontEleganceListBLL storefrontEleganceListBLL = new zlzw.BLL.StorefrontEleganceListBLL();
storefrontEleganceListBLL.Update(storefrontEleganceListModal);
}
else
{
//添加保存
zlzw.Model.StorefrontEleganceListModal storefrontEleganceListModal = new zlzw.Model.StorefrontEleganceListModal();
storefrontEleganceListModal.DictionaryKey = drpStorefrontEleganceType.SelectedValue; //所属门店
storefrontEleganceListModal.Other01 = drpRegionList.SelectedValue;
storefrontEleganceListModal.StorefrontEleganceTitle = txbStorefrontEleganceTitle.Text; //门店名称
storefrontEleganceListModal.StorefrontEleganceDescription = txbStorefrontEleganceDescription.Text; //门店简介
storefrontEleganceListModal.PushJobs = txbPushJobs.Text; //主推岗位
if (btnStorefrontEleganceHeadImage.PostedFile.ContentLength > 0)
{
string fileName = DateTime.Now.Ticks.ToString() + "_" + btnStorefrontEleganceHeadImage.FileName;
btnStorefrontEleganceHeadImage.SaveAs(Server.MapPath("~/storefrontEleganceImages/" + fileName));
storefrontEleganceListModal.StorefrontEleganceHeadImage = "~/storefrontEleganceImages/" + fileName;//保存页面头部门店介绍路径
}
else
{
storefrontEleganceListModal.StorefrontEleganceHeadImage = ViewState["StorefrontEleganceHeadImage"].ToString();
}
storefrontEleganceListModal.IsEnable = 1;
storefrontEleganceListModal.StorefrontEleganceGUID = Guid.NewGuid();//店面风采GUID
storefrontEleganceListModal.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
zlzw.BLL.StorefrontEleganceListBLL storefrontEleganceListBLL = new zlzw.BLL.StorefrontEleganceListBLL();
storefrontEleganceListBLL.Add(storefrontEleganceListModal);
}
// 2. Close this window and Refresh parent window
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
try
{
string sqlCmd = "";
DataTable dt = new DataTable();
int userStatus = CkeckBox_enabled.Checked ? 1 : 0;
sqlCmd = "select * from x_user where name='" + txb_workNo.Text + "' and Enabled=1";//是否在办公系统中开通相应账户
SqlSel.GetSqlSel(ref dt, sqlCmd);
if (dt.Rows.Count > 0)
{
int fId = Convert.ToInt32(dt.Rows[0]["id"]); //用户流水id
if (string.IsNullOrEmpty(userId)) //新建用户
{
sqlCmd = "insert into PLM_Sys_UserList (userId,enabled) values (";
sqlCmd += "'" + txb_workNo.Text + "','" + userStatus + "')";
SqlSel.ExeSql(sqlCmd);
//删除用户现有角色
sqlCmd += "delete from OA_Sys_UserRole where userid=(select id from x_user where name='" + userId + "')";
SqlSel.ExeSql(sqlCmd);
//更新角色信息
string[] selectValueArray = ckb_roleList.SelectedValueArray;
foreach (string item in selectValueArray)
{
sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values (";
sqlCmd += "'" + fId + "','" + item + "','" + DateTime.Now + "')";
SqlSel.ExeSql(sqlCmd);
}
}
else //更新用户信息
{
sqlCmd = "update PLM_Sys_UserList set enabled='" + userStatus + "' where userId='" + userId + "'";
SqlSel.ExeSql(sqlCmd);
//删除用户现有角色
sqlCmd += "delete from OA_Sys_UserRole where userid=(select id from x_user where name='" + userId + "')";
SqlSel.ExeSql(sqlCmd);
string[] selectValueArray = ckb_roleList.SelectedValueArray;
foreach (string item in selectValueArray)
{
sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values (";
sqlCmd += "'" + fId + "','" + item + "','" + DateTime.Now + "')";
SqlSel.ExeSql(sqlCmd);
}
}
Alert.ShowInTop("保存成功！");
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
else
{
Alert.ShowInTop("系统不存在此工号！请查正或联系管理员。");
return;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}