AddPhotographerConferenceSmallForm.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Web.UI.WebControls;
  10. using System.Windows.Forms;
  11. namespace LYFZ.Software.MainBusiness.MembershipManage.SetSmallForm
  12. {
  13. public partial class AddPhotographerConferenceSmallForm : LYFZ.Software.UI.MembershipManage.SetSmallForm.AddPhotographerConferenceSmallForm
  14. {
  15. LYFZ.BLL.BLL_ErpMemberCard mcbll = new BLL.BLL_ErpMemberCard();
  16. LYFZ.BLL.BLL_ErpMemberCardGradeSet mcgsbll = new BLL.BLL_ErpMemberCardGradeSet();
  17. LYFZ.BLL.BLL_ErpMemberCardValidity mcvybll = new BLL.BLL_ErpMemberCardValidity();
  18. LYFZ.BLL.BLL_ErpMemberCardPhotographerMain mcpmbll = new BLL.BLL_ErpMemberCardPhotographerMain();
  19. LYFZ.BLL.BLL_ErpMemberCardPhotographerVice mcpvbll = new BLL.BLL_ErpMemberCardPhotographerVice();
  20. LYFZ.BLL.BLL_ErpMemberCardPhotographerGiftSet mcpgsbll = new BLL.BLL_ErpMemberCardPhotographerGiftSet();
  21. public AddPhotographerConferenceSmallForm()
  22. {
  23. this.btnUpdateValidity.Click += btnUpdateValidity_Click;
  24. this.chkValidity.CheckedChanged += chkValidity_CheckedChanged;
  25. }
  26. private DataTable tbl_Grade = new DataTable();
  27. private DataTable tbl_Gift = new DataTable();
  28. DataTable tblMain = new DataTable();
  29. /// <summary>
  30. /// 会员卡编号
  31. /// </summary>
  32. public string StrNumber = "";
  33. /// <summary>
  34. /// 是否保存
  35. /// </summary>
  36. public bool IsSaveed = false;
  37. /// <summary>
  38. /// 窗体加载事件
  39. /// </summary>
  40. /// <param name="sender"></param>
  41. /// <param name="e"></param>
  42. protected override void AddPhotographerConferenceSmallForm_Shown(object sender, EventArgs e)
  43. {
  44. if (!LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.OrdersReceivablesCompetence, LYFZ.CustomAttributes.OperatingAuthority.OrderPaymentMethodSet))
  45. { this.btnSet.Enabled = false; }
  46. if (!LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.MemberManage, LYFZ.CustomAttributes.OperatingAuthority.Member_PhotographerOpenCard))
  47. { this.btnSave.Enabled = false; }
  48. }
  49. /// <summary>
  50. /// 窗体加载事件
  51. /// </summary>
  52. /// <param name="sender"></param>
  53. /// <param name="e"></param>
  54. protected override void AddPhotographerConferenceSmallForm_Load(object sender, EventArgs e)
  55. {
  56. tblMain = mcbll.GetView_Custom("tb_ErpMemberCardPhotographerMain", StrWhere: "").Tables[0];
  57. tbl_Grade = mcgsbll.GetList("ID != 1 and Mcgs_OpenCardAoumnt>0", "Mcgs_AmountStart ASC").Tables[0];
  58. tbl_Grade.PrimaryKey = new DataColumn[] { tbl_Grade.Columns["Mcgs_Number"] };
  59. for (int i = 0; i < tbl_Grade.Rows.Count; i++)
  60. { this.cmbMemberType.Items.Add(new ListItem(tbl_Grade.Rows[i]["Mcgs_GradeName"].ToString().Trim(), tbl_Grade.Rows[i]["Mcgs_Number"].ToString().Trim())); }
  61. tbl_Gift = mcpgsbll.GetList("", "ID ASC").Tables[0];
  62. #region 加载有效期
  63. bool IsValidity = false;
  64. DataTable dt = mcbll.GetView_Custom("tb_ErpMemberCardValidity", StrWhere: "Mcvy_Number = '" + this.StrNumber + "' And Mcvy_Type = " + ((int)LYFZ.EnumPublic.MemberFunctionAttribute.新摄会) + "", ShowColumnName: "ID,Mcvy_ValidityTime").Tables[0];
  65. if (dt.Rows.Count > 0)
  66. {
  67. this.chkValidity.Tag = dt.Rows[0]["ID"].ToString().Trim();
  68. if (!string.IsNullOrEmpty(LYFZ.Command.Command_Validate.DateTimeToString(dt.Rows[0]["Mcvy_ValidityTime"].ToString().Trim())))
  69. {
  70. IsValidity = true;
  71. this.dtpValidity.DateValue = dt.Rows[0]["Mcvy_ValidityTime"].ToString().Trim();
  72. this.chkValidity.Checked = false;
  73. }
  74. }
  75. if (!IsValidity)
  76. {
  77. this.dtpValidity.DateValue = "";
  78. this.chkValidity.Checked = true;
  79. }
  80. #endregion
  81. LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_PaymentMethod(this.cmbPaymentMethod, false);
  82. }
  83. /// <summary>
  84. /// 保存
  85. /// </summary>
  86. /// <param name="sender"></param>
  87. /// <param name="e"></param>
  88. protected override void btnSave_Click(object sender, EventArgs e)
  89. {
  90. if (this.dgvUpgradeData.Rows.Count <= 0)
  91. { MessageBoxCustom.Show("摄友详情无数据"); return; }
  92. if (this.cmbPaymentMethod.Text.Trim() == "")
  93. { MessageBoxCustom.Show("请选择收款方式"); return; }
  94. if (MessageBoxCustom.Show("您确定要办理" + this.cmbMemberType.Text.Trim() + "并且收款" + this.dgvUpgradeData.Rows[0].Cells["Column1"].Value.ToString().Trim() + "元人民币吗?", "温馨提示", MessageBoxButtons.YesNo) == DialogResult.No)
  95. { return; }
  96. List<Helper.CommandInfo> clist = new List<Helper.CommandInfo>();
  97. DateTime strTime = SDateTime.Now;
  98. ListItem lItem = (ListItem)this.cmbMemberType.SelectedItem;
  99. string strUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
  100. LYFZ.Model.Model_ErpMemberCardPhotographerMain modelm = new Model.Model_ErpMemberCardPhotographerMain();
  101. modelm.Mcpm_MyNumber = "my" + LYFZ.Command.Command_Validate.DateTimeToString(SDateTime.Now, "yyyyMMddHHmmssfff");
  102. modelm.Mcpm_Number = this.StrNumber;
  103. modelm.Mcpm_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
  104. modelm.Mcpm_GradeNumber = lItem.Value.Trim();
  105. modelm.Mcpm_GradeName = lItem.Text.Trim();
  106. modelm.Mcpm_UpgradeAoumnt = Convert.ToDecimal(this.dgvUpgradeData.Rows[0].Cells["Column1"].Value);
  107. modelm.Mcpm_UpgradePoints = Convert.ToInt32(this.dgvUpgradeData.Rows[0].Cells["Column2"].Value);
  108. modelm.Mcpm_PaymentMethod = this.cmbPaymentMethod.Tag.ToString().Trim();
  109. modelm.Mcpm_PaymentName = strUserID;
  110. modelm.Mcpm_BackAoumnt = Convert.ToDecimal(this.dgvUpgradeData.Rows[0].Cells["Column3"].Value);
  111. modelm.Mcpm_BackStatus = "0";
  112. modelm.Mcpm_OKBackAoumnt = 0;
  113. modelm.Mcpm_JingShouRen = "";
  114. modelm.Mcpm_UpgradeAoumntAudit = "";
  115. modelm.Mcpm_UpgradeAoumntAuditName = "";
  116. modelm.Mcpm_UpgradeAoumntAuditRemark = "";
  117. modelm.Mcpm_OKBackAoumntAudit = "";
  118. modelm.Mcpm_OKBackAoumntAuditName = "";
  119. modelm.Mcpm_OKBackAoumntAuditRemark = "";
  120. modelm.Mcpm_CreateDatetime = strTime;
  121. modelm.Mcpm_CreateName = strUserID;
  122. clist.Add(mcpmbll.GetAddCommandInfo(modelm));
  123. LYFZ.Model.Model_ErpMemberCardPhotographerVice modelv = null;
  124. for (int i = 0; i < this.dgvGift.Rows.Count; i++)
  125. {
  126. modelv = new Model.Model_ErpMemberCardPhotographerVice();
  127. modelv.Mcpv_MyNumber = modelm.Mcpm_MyNumber;
  128. modelv.Mcpv_Number = this.StrNumber;
  129. modelv.Mcpv_GradeNumber = lItem.Value.Trim();
  130. modelv.Mcpv_GradeName = lItem.Text.Trim();
  131. modelv.Mcpv_GiftNumber = this.dgvGift.Rows[i].Cells["G_3"].Value.ToString().Trim();
  132. modelv.Mcpv_GiftName = this.dgvGift.Rows[i].Cells["G_1"].Value.ToString().Trim();
  133. modelv.Mcpv_GiftClassCode = this.dgvGift.Rows[i].Cells["G_4"].Value.ToString().Trim();
  134. modelv.Mcpv_GiftClassName = this.dgvGift.Rows[i].Cells["G_5"].Value.ToString().Trim();
  135. modelv.Mcpv_GiftType = this.dgvGift.Rows[i].Cells["G_6"].Value.ToString().Trim();
  136. modelv.Mcpv_UseStatus = "0";
  137. modelv.Mcpv_JingShouRen = "";
  138. modelv.Mcpv_CreateDatetime = strTime;
  139. modelv.Mcpv_CreateName = strUserID;
  140. clist.Add(mcpvbll.GetAddCommandInfo(modelv));
  141. }
  142. string StrGradeName = LYFZ.BLL.OrderPayment_Member.GetMemberUpgradeData(this.StrNumber, PhotographerUpgradeAmount: modelm.Mcpm_UpgradeAoumnt);
  143. if (StrGradeName != "")
  144. {
  145. LYFZ.Model.Model_ErpMemberCard mc = mcbll.GetModel("Mc_Number", this.StrNumber);
  146. mc.Mc_CardType = this.cmbMemberType.Text.Trim();
  147. mc.Mc_UpdateDateTime = strTime;
  148. mc.Mc_UpdateName = strUserID;
  149. clist.Add(mcbll.GetUpdateCommandInfo(mc));
  150. }
  151. #region 会员有效期
  152. LYFZ.Model.Model_ErpMemberCardValidity modelValidity = null;
  153. LYFZ.Model.Model_ErpMemberCard MCrad = mcbll.GetModel("Mc_Number", this.StrNumber);
  154. if (this.chkValidity.Tag == null)
  155. {
  156. modelValidity = new Model.Model_ErpMemberCardValidity();
  157. modelValidity.Mcvy_Number = this.StrNumber;
  158. modelValidity.Mcvy_Type = (int)LYFZ.EnumPublic.MemberFunctionAttribute.新摄会;
  159. if (this.chkValidity.Checked)
  160. { modelValidity.Mcvy_ValidityTime = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime(); }
  161. else
  162. { modelValidity.Mcvy_ValidityTime = Convert.ToDateTime(this.dtpValidity.DateValue).AddDays(1).AddSeconds(-1); }
  163. modelValidity.Mcvy_CreateDatetime = strTime;
  164. modelValidity.Mcvy_CreateName = strUserID;
  165. clist.Add(mcvybll.GetAddCommandInfo(modelValidity));
  166. string StrLogTime = "";
  167. if (string.IsNullOrEmpty(LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime)))
  168. { StrLogTime += "‘永久有效’"; }
  169. else
  170. { StrLogTime += "’" + LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime, "yyyy-MM-dd HH:mm:ss") + "’"; }
  171. clist.Add(LYFZ.BLL.OrderPayment_Member.GetValidityLogs("[新摄会新增]", MCrad.Mc_CradNumber, modelValidity.Mcvy_Type, StrLogTime,strUserID));
  172. }
  173. else
  174. {
  175. modelValidity = mcvybll.GetModel(Convert.ToInt32(this.chkValidity.Tag));
  176. DateTime dtTime = modelValidity.Mcvy_ValidityTime;
  177. string StrLogTime = "";
  178. if (string.IsNullOrEmpty(LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime)))
  179. { StrLogTime += "‘永久有效’"; }
  180. else
  181. { StrLogTime += "’" + LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime, "yyyy-MM-dd HH:mm:ss") + "’"; }
  182. if (this.chkValidity.Checked)
  183. { modelValidity.Mcvy_ValidityTime = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime(); }
  184. else
  185. { modelValidity.Mcvy_ValidityTime = Convert.ToDateTime(this.dtpValidity.DateValue).AddDays(1).AddSeconds(-1); }
  186. if (LYFZ.Command.Command_Validate.DateTimeToString(dtTime) != LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime))
  187. {
  188. modelValidity.Mcvy_UpdateDatetime = strTime;
  189. modelValidity.Mcvy_UpdateName = strUserID;
  190. clist.Add(mcvybll.GetUpdateCommandInfo(modelValidity));
  191. if (string.IsNullOrEmpty(LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime)))
  192. { StrLogTime += "修改为‘永久有效’"; }
  193. else
  194. { StrLogTime += "修改为‘" + LYFZ.Command.Command_Validate.DateTimeToString(modelValidity.Mcvy_ValidityTime, "yyyy-MM-dd HH:mm:ss") + "’"; }
  195. clist.Add(LYFZ.BLL.OrderPayment_Member.GetValidityLogs("[新摄会修改]", MCrad.Mc_CradNumber, modelValidity.Mcvy_Type, StrLogTime,strUserID));
  196. }
  197. }
  198. #endregion
  199. if (clist.Count > 0)
  200. {
  201. if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) > 0)
  202. {
  203. this.IsSaveed = true;
  204. if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.MemberManage, LYFZ.CustomAttributes.OperatingAuthority.Print))
  205. {
  206. LYFZ.Software.MainBusiness.MembershipManage.SuperSmallForm.RechargePrintMessageSuperSmallForm frmMesg = new SuperSmallForm.RechargePrintMessageSuperSmallForm();
  207. frmMesg.lblNameTip = "办理成功!";
  208. frmMesg.ShowDialog();
  209. if (frmMesg.IsSaveed)
  210. {
  211. Hashtable htData = new Hashtable();
  212. htData["strNumber"] = this.StrNumber;
  213. htData["strMyNumber"] = modelm.Mcpm_MyNumber.Trim();
  214. LYFZ.Software.MainBusiness.ReportPrint.ReportFixedFormat.PrintFixedFormat(LYFZ.EnumPublic.PrintTypeEnum.新摄会收款, htData);
  215. }
  216. }
  217. this.Close();
  218. }
  219. else
  220. { MessageBoxCustom.Show("办理失败!"); }
  221. }
  222. }
  223. /// <summary>
  224. /// 取消
  225. /// </summary>
  226. /// <param name="sender"></param>
  227. /// <param name="e"></param>
  228. protected override void btnCancel_Click(object sender, EventArgs e)
  229. {
  230. this.Close();
  231. }
  232. /// <summary>
  233. /// 会员等级选择事件
  234. /// </summary>
  235. /// <param name="sender"></param>
  236. /// <param name="e"></param>
  237. protected override void cmbMemberType_SelectedIndexChanged(object sender, EventArgs e)
  238. {
  239. if (this.cmbMemberType.Items.Count > 0)
  240. {
  241. ListItem lItem = (ListItem)this.cmbMemberType.SelectedItem;
  242. DataRow dtRow = tbl_Grade.Rows.Find(lItem.Value);
  243. this.dgvUpgradeData.Rows.Clear();
  244. this.dgvGift.Rows.Clear();
  245. if (tblMain.Rows.Count > 0)
  246. {
  247. DataRow[] dtRow3 = tblMain.Select("Mcpm_Number = '" + this.StrNumber + "' and Mcpm_GradeNumber = '" + lItem.Value.Trim() + "'");
  248. if (dtRow3.Length > 0)
  249. { this.cmbMemberType.Text = ""; MessageBoxCustom.Show("您已办有此新摄会类型,不能重复办理"); return; }
  250. }
  251. DataGridViewRow dgvr = new DataGridViewRow();
  252. DataGridViewCell cell = null;
  253. cell = new DataGridViewTextBoxCell();
  254. cell.Value = dtRow["Mcgs_OpenCardAoumnt"].ToString().Trim();
  255. dgvr.Cells.Add(cell);
  256. cell = new DataGridViewTextBoxCell();
  257. cell.Value = dtRow["Mcgs_ReturnNeededPoints"].ToString().Trim();
  258. dgvr.Cells.Add(cell);
  259. cell = new DataGridViewTextBoxCell();
  260. cell.Value = dtRow["Mcgs_ReturnAoumnt"].ToString().Trim();
  261. dgvr.Cells.Add(cell);
  262. this.dgvUpgradeData.Rows.Add(dgvr);
  263. DataRow[] dtRow2 = tbl_Gift.Select("Mcpgs_GradeNumber = '" + lItem.Value + "'");
  264. for (int i = 0; i < dtRow2.Length; i++)
  265. {
  266. DataGridViewRow dgvr2 = new DataGridViewRow();
  267. DataGridViewCell cell2 = null;
  268. cell2 = new DataGridViewTextBoxCell();
  269. cell2.Value = dtRow2[i]["Mcpgs_GiftName"].ToString().Trim();
  270. dgvr2.Cells.Add(cell2);
  271. cell2 = new DataGridViewTextBoxCell();
  272. cell2.Value = "未使用";
  273. dgvr2.Cells.Add(cell2);
  274. cell2 = new DataGridViewTextBoxCell();
  275. cell2.Value = dtRow2[i]["Mcpgs_GiftNumber"].ToString().Trim();
  276. dgvr2.Cells.Add(cell2);
  277. cell2 = new DataGridViewTextBoxCell();
  278. cell2.Value = dtRow2[i]["Mcpgs_GiftClassCode"].ToString().Trim();
  279. dgvr2.Cells.Add(cell2);
  280. cell2 = new DataGridViewTextBoxCell();
  281. cell2.Value = dtRow2[i]["Mcpgs_GiftClassName"].ToString().Trim();
  282. dgvr2.Cells.Add(cell2);
  283. cell2 = new DataGridViewTextBoxCell();
  284. cell2.Value = dtRow2[i]["Mcpgs_GiftType"].ToString().Trim();
  285. dgvr2.Cells.Add(cell2);
  286. this.dgvGift.Rows.Add(dgvr2);
  287. }
  288. }
  289. }
  290. /// <summary>
  291. /// 窗体关闭时发生
  292. /// </summary>
  293. /// <param name="sender"></param>
  294. /// <param name="e"></param>
  295. protected override void AddPhotographerConferenceSmallForm_FormClosed(object sender, FormClosedEventArgs e)
  296. {
  297. GoldManagementSmallForm frm1 = (GoldManagementSmallForm)this.Owner;
  298. if (frm1 != null)
  299. { frm1.RefreshParentForm = IsSaveed; }
  300. }
  301. /// <summary>
  302. /// 设置
  303. /// </summary>
  304. /// <param name="sender"></param>
  305. /// <param name="e"></param>
  306. protected override void btnSet_Click(object sender, EventArgs e)
  307. {
  308. LYFZ.Software.MainBusiness.InitialSet.FrmSystemSet frm = new InitialSet.FrmSystemSet();
  309. frm.TypeName = "BEBACCAFCCEAGAIHH";
  310. frm.Version = "Version";
  311. if (frm.ShowDialog() == DialogResult.OK)
  312. { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_PaymentMethod(this.cmbPaymentMethod); }
  313. }
  314. /// <summary>
  315. /// 修改有效期
  316. /// </summary>
  317. /// <param name="sender"></param>
  318. /// <param name="e"></param>
  319. void btnUpdateValidity_Click(object sender, EventArgs e)
  320. {
  321. if (!LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.MemberManage, CustomAttributes.OperatingAuthority.ValidityDateTime))
  322. {
  323. LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.AuthorizeLoginSuperSmallForm frm = new DoorCityProcess.SuperSmallForm.AuthorizeLoginSuperSmallForm("MemberManage", CustomAttributes.OperatingAuthority.ValidityDateTime);
  324. if (frm.ShowDialog() == DialogResult.No)
  325. { return; }
  326. if (!LYFZ.BLL.BLL_ErpUser.GetRights(frm.CurrentAuthorizeUserRights.MemberManage, CustomAttributes.OperatingAuthority.ValidityDateTime, frm.User_BelongRoles))
  327. {
  328. frm.SetAuthorizationResult(String.Format("授权失败,授权人没有'会员管理{0}'权限", LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.AuthorizeLoginSuperSmallForm.ConvertEnumToDescription(CustomAttributes.OperatingAuthority.ValidityDateTime).ToString()));
  329. return; }
  330. else {
  331. frm.SetAuthorizationResult();
  332. }
  333. }
  334. if (this.chkValidity.Checked)
  335. {
  336. this.chkValidity.Enabled = true;
  337. this.dtpValidity.Enabled = false;
  338. }
  339. else
  340. {
  341. this.chkValidity.Enabled = true;
  342. this.dtpValidity.Enabled = true;
  343. }
  344. }
  345. string StrValidityTime = "";
  346. /// <summary>
  347. /// 永久选择事件
  348. /// </summary>
  349. /// <param name="sender"></param>
  350. /// <param name="e"></param>
  351. void chkValidity_CheckedChanged(object sender, EventArgs e)
  352. {
  353. if (this.chkValidity.Checked)
  354. {
  355. this.StrValidityTime = this.dtpValidity.DateValue;
  356. this.dtpValidity.DateValue = "";
  357. this.dtpValidity.Enabled = false;
  358. }
  359. else
  360. {
  361. this.dtpValidity.Enabled = true;
  362. this.dtpValidity.DateValue = this.StrValidityTime;
  363. }
  364. }
  365. }
  366. }