private void btnSave_Click(object sender, EventArgs e)
{
string createdby = txtUser.Text.Trim();
string created = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string department = txtDepartment.Text.Trim();
string key = txtKey.Text.Trim();
string remarks = txtRemarks.Text.Trim();
string sectHead = UserUtil.GetSectionHead(UserUtil.GetSect(GlobalService.User));
string divHead = UserUtil.GetDivisionHead(UserUtil.GetDivision(GlobalService.User));
string adm1st = "Sammy Chow Chi To (周志滔)";
string adm2nd = "Sammy Chow Chi To (周志滔)";
string query = string.Format("insert into TB_ADM_FORM_KEY (ak_createdby, ak_created, ak_department, ak_key, ak_remarks, ak_sect, ak_div, ak_adm1st, ak_adm2nd)" +
" values (N'{0}', '{1}', N'{2}', N'{3}', N'{4}', N'{5}', N'{6}', N'{7}', N'{8}')", createdby, created, department, key, remarks, sectHead, divHead, adm1st, adm2nd);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(sectHead, "kmhk.local"), "kmhk.local");
string text = "Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail("", GlobalService.User, from, to, body, "Approval Required - 複製鎖匙依賴");
MessageBox.Show("Record has been saved.");
DialogResult = DialogResult.OK;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtAttachment.Text == "")
{
switch (MessageBox.Show("No Attachment found. Continue?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
string query = string.Format("update TB_FORM_R3 set r_itattachment = N'{0}', r_status = N'經管承認中' where r_chaseno = '{1}'", "", _chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
break;
case DialogResult.No:
break;
}
}
else
{
string query = string.Format("update TB_FORM_R3 set r_itattachment = N'{0}', r_status = N'經管承認中' where r_chaseno = '{1}'", txtAttachment.Text.Trim(), _chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
}
string from = AdUtil.GetEmailByUsername(txtApplicant.Text.Trim(), "kmhk.local");
string to = AdUtil.GetEmailByUsername(_cmApprover, "kmhk.local");
string text = "IT Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail(_chaseno, from, to, body, "R3申請", txtApplicant.Text.Trim());
}
private void btnApprove_Click(object sender, EventArgs e)
{
string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string text = _status == "科責承認中" ? string.Format("update TB_ACC_OUTSTANDING set o_divapproval = 'Yes', o_divapprovaldate = '{0}', o_status = N'會計處理中' where o_invoice = '{1}'", now, _invoice)
: _status == "會計處理中" ? string.Format("update TB_ACC_OUTSTANDING set o_staffapproval = 'Yes', o_staffapprovaldate = '{0}', o_status = N'會計承認中' where o_invoice = '{1}'", now, _invoice)
: string.Format("update TB_ACC_OUTSTANDING set o_accapproval = 'Yes', o_accapprovaldate = '{0}', o_status = N'申請處理完成' where o_invoice = '{1}'", now, _invoice);
DataServiceCM.GetInstance().ExecuteNonQuery(text);
string applicant = AccUtil.GetApplicant(_invoice);
string div = AccUtil.GetDivisionApprover(_invoice);
string staff = AccUtil.GetAccStaff(_invoice);
string acc = AccUtil.GetAccApprover(_invoice);
if (_status == "科責承認中")
{
EformUtil.SendApprovalEmail(_invoice, applicant, AdUtil.GetEmailByUsername(applicant, "kmhk.local"), AdUtil.GetEmailByUsername(staff, "kmhk.local"), "", "Outstanding Slip - " + _invoice);
}
if (_status == "會計處理中")
{
EformUtil.SendApprovalEmail(_invoice, applicant, AdUtil.GetEmailByUsername(applicant, "kmhk.local"), AdUtil.GetEmailByUsername(acc, "kmhk.local"), "", "Outstanding Slip - " + _invoice);
}
if (_status == "會計承認中")
{
EformUtil.SendFinishedEmail(_invoice, acc, AdUtil.GetEmailByUsername(acc, "kmhk.local"), AdUtil.GetEmailByUsername(applicant, "kmhk.local"), "Outstanding Slip Application Finished - " + _invoice, "You Outstanding Slip Application has been finished.");
}
DialogResult = DialogResult.OK;
}
private void btnReject_Click(object sender, EventArgs e)
{
string query = string.Format("update TB_CM_DEBIT set d_status = N'拒絕承認' where d_docno = '{0}'", _docno);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string sect = "";
string div = "";
string dept = "";
string createdby = "";
string text = string.Format("select d_sect, d_div, d_dept, d_createdby from TB_CM_DEBIT where d_docno = '{0}'", _docno);
using (IDataReader reader = DataServiceCM.GetInstance().ExecuteReader(text))
{
while (reader.Read())
{
sect = reader.GetString(0).Trim();
div = reader.GetString(1).Trim();
dept = reader.GetString(2).Trim();
createdby = reader.GetString(3).Trim();
}
}
string subject = "Debit/Credit Note Application has been Rejected";
string content = "Dear Sir/Madam,\n\nYour Debit/Credit Note Application has been Rejected. Please go to MyCloud to revise or apply a new application.\n\nThis is system message, please do not reply.";
EformUtil.SendRejectEmail(_docno, GlobalService.User, AdUtil.GetEmailByUsername(GlobalService.User, "kmhk.local"), AdUtil.GetEmailByUsername(createdby, "kmhk.local"), subject, content);//cc?
}
private void button1_Click(object sender, EventArgs e)
{//
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername("Lai Sui Mei(黎少薇,Olive)", "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername("Hara Masatoshi(原雅俊)", "kmhk.local"), "kmhk.local");
EformUtil.SendR3ApprovalEmail("IT-R-0000031", "New User R/3 ID Request,Authority same as Katty Zhang ID: H160004", "", "", from, to, "Lai Sui Mei(黎少薇,Olive)");
}
private void btnSave_Click(object sender, EventArgs e)
{
dgvAsset.EndEdit();
if (!IsDataValid(dgvAsset))
{
MessageBox.Show("Invalid input found.");
return;
}
string applicant = DataUtil.GetApplicant(GlobalService.ChaseNo);
string head = DataUtil.GetHead(applicant);
string approval = DataUtil.IsItemApproved(GlobalService.ChaseNo) ? "Yes" : "No";
string chaseno = DataUtil.GetAssetChaseNo();
string status = approval == "Yes" ? "I.T.處理中" : "上司承認中";
foreach (DataGridViewRow row in dgvAsset.Rows)
{
if (row.IsNewRow)
{
continue;
}
string category = row.Cells[0].Value.ToString().Trim();
string name = row.Cells[1].Value.ToString().Trim();
string start = row.Cells[2].Value.ToString().Trim();
string preReturn = row.Cells[3].Value.ToString().Trim();
string inout = row.Cells[4].Value.ToString().Trim();
string assigned = row.Cells[5].Value.ToString().Trim();
string query = string.Format("insert into TB_FORM_LOANING (l_name, l_category, l_start, l_end, l_created, l_applicant, l_status, l_refno, l_approval, l_approver, l_chaseno, l_remarks, l_handledby)" +
" values (N'{0}', N'{1}', '{2}', '{3}', '{4}', N'{5}', N'{6}', '{7}', '{8}', N'{9}', '{10}', '{11}', N'{12}')", name, category, start, preReturn, DateTime.Today.ToString("yyyy/MM/dd"), applicant, status, GlobalService.ChaseNo, approval, head, chaseno, inout, assigned);
DataService.GetInstance().ExecuteNonQuery(query);
//string text = string.Format("update TB_IT_ASSET set a_status = N'借用中', a_refno = '{0}' where a_name = '{1}'", GlobalService.ChaseNo, name);
//DataServiceIT.GetInstance().ExecuteNonQuery(text);
}
if (approval == "No")
{
string from = AdUtil.GetEmailByUsername(applicant, "kmhk.local");
string to = AdUtil.GetEmailByUsername(head, "kmhk.local");
EformUtil.SendApprovalEmail(GlobalService.ChaseNo, from, to, "Approval Required for 資產外借", "資產外借", applicant);
}
GlobalService.SavedForm = "asset";
if (SavedEvent != null)
{
SavedEvent(this, new EventArgs());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string category = cbCategory.SelectedItem.ToString();
string item = cbItem.SelectedItem.ToString();
string date = dtpComplete.Value.ToString("yyyy/MM/dd");
string status = cbStatus.SelectedItem.ToString();
string assigned = cbAssign.SelectedItem.ToString().Trim();
rtbRemarks.SaveFile("temp.rtf");
FileStream stream = new FileStream("temp.rtf", FileMode.Open, FileAccess.Read);
int size = Convert.ToInt32(stream.Length);
Byte[] rtf = new Byte[size];
stream.Read(rtf, 0, size);
string applicant = DataUtil.GetApplicant(GlobalService.ChaseNo);
string head = DataUtil.GetHead(applicant);
string approval = DataUtil.IsItemApproved(GlobalService.ChaseNo) ? "Yes" : "No";
string chaseno = DataUtil.GetDevelopChaseNo();
string st = approval == "Yes" ? "I.T處理中" : "上司承認中";//status == "Completed" ? "申請處理完成" : status == "Processing" ? "I.T.處理中" : "取消";
string query = string.Format("if not exists (select * from TB_FORM_DEVELOP where d_chaseno = '{0}') insert into TB_FORM_DEVELOP (d_chaseno, d_category, d_item, d_estimate, d_status, d_remarks, d_applicant, d_approver, d_approval, d_refno, d_created, d_handledby)" +
" values ('{0}', '{1}', N'{2}', '{3}', N'{4}', @Remarks, N'{5}', N'{6}', '{7}', '{8}', '{9}', N'{10}') else update TB_FORM_DEVELOP set d_category = '{1}', d_item = N'{2}', d_estimate = '{3}', d_status = N'{4}', d_remarks = @Remarks where d_chaseno = '{0}'", chaseno, category, item, date, st, applicant, head, approval, GlobalService.ChaseNo, DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), assigned);
SqlCommand cmd = new SqlCommand(query, DataService.GetInstance().Connection);
SqlParameter param = new SqlParameter("@Remarks", SqlDbType.Image, rtf.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rtf);
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
GlobalService.SavedForm = "develop";
if (approval == "No")
{
string from = AdUtil.GetEmailByUsername(applicant, "kmhk.local");
string to = AdUtil.GetEmailByUsername(head, "kmhk.local");
string[] attachments = _attachList.Select(x => x.FilePath).ToArray();
EformUtil.SendApprovalEmailWithAttachment(GlobalService.ChaseNo, from, to, "Approval Required for 工具開發/修改", "工具開發/修改", applicant, attachments);
//EformUtil.SendApprovalEmail(GlobalService.ChaseNo, from, to, "Approval Required for 權限及軟件安裝", "權限及軟件安裝", applicant);
}
if (SavedEvent != null)
{
SavedEvent(this, new EventArgs());
}
}
private void SaveData()
{
string applicant = GlobalService.User;
string category = cbType.SelectedItem.ToString().Trim();
string type = cbR3Type.SelectedItem.ToString().Trim();
string title = "R3申請 - " + category + type;
string r3id = txtR3Id.Text.Trim();
string request = txtRequest.Text.Trim();
string reason = txtReason.Text.Trim();
string start = dtpStart.Value.ToString("yyyy/MM/dd");
string attachment = txtAttachment.Text.Trim() != "" ? txtAttachment.Text.Trim() : "";
string approver = txtHead.Text.Trim();
string cmApprover = GlobalService.User; //"Hara Masatoshi(原雅俊)";
string itApprover = GlobalService.User; //"Chan Fai Lung(陳輝龍,Onyx)";
string chaseno = GetLatestChaseno();
string filePath = "";
if (attachment != "")
{
string filename = Path.GetFileName(attachment);
string directory = @"\\kdthk-dm1\project\kdthk-dm\Forms\R3 Application\" + GlobalService.User + @"\";
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
File.Copy(attachment, directory + filename, true);
filePath = directory + filename;
}
string query = string.Format("insert into TB_FORM_R3 (r_applicant, r_title, r_category, r_type, r_r3id, r_request, r_reason" +
", r_start, r_attachment, r_approver, r_cmapprover, r_itapprover, r_created, r_chaseno) values (N'{0}', N'{1}', N'{2}', '{3}', N'{4}', N'{5}', N'{6}', '{7}', N'{8}', N'{9}', N'{10}', N'{11}', '{12}', '{13}')",
applicant, title, category, type, r3id, request, reason, start, filePath, approver, cmApprover, itApprover, DateTime.Today.ToString("yyyy/MM/dd"), chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(approver, "kmhk.local"), "kmhk.local");
string text = "IT Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail(chaseno, GlobalService.User, from, to, body, title);
DialogResult = DialogResult.OK;
}
private void btnReject_Click(object sender, EventArgs e)
{
string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string text = _status == "科責承認中" ? string.Format("update TB_ACC_OUTSTANDING set o_divapproval = 'No', o_divapprovaldate = '{0}', o_status = N'科責已拒絕' where o_invoice = '{1}'", now, _invoice)
: _status == "會計處理中" ? string.Format("update TB_ACC_OUTSTANDING set o_staffapproval = 'No', o_staffapprovaldate = '{0}', o_status = N'會計已拒絕' where o_invoice = '{1}'", now, _invoice)
: string.Format("update TB_ACC_OUTSTANDING set o_accapproval = 'No', o_accapprovaldate = '{0}', o_status = N'會計已拒絕' where o_invoice = '{1}'", now, _invoice);
DataServiceCM.GetInstance().ExecuteNonQuery(text);
string applicant = AccUtil.GetApplicant(_invoice);
EformUtil.SendRejectEmail(_invoice, GlobalService.User, AdUtil.GetEmailByUsername(GlobalService.User, "kmhk.local"), AdUtil.GetEmailByUsername(applicant, "kmhk.local"), "Outstanding Slip Rejected - " + _invoice, "Your Outstanding Slip has been rejected by " + GlobalService.User);
DialogResult = DialogResult.OK;
}
private void btnApprove_Click(object sender, EventArgs e)
{
string query = string.Format("select d_div, d_dept, d_mcstaff, d_mcreviewer, d_mcfinal, d_createdby, d_reason from TB_CM_DEBIT where d_docno = '{0}'", _docno);
string target = "";
string applicant = "";
string reason = "";
using (IDataReader reader = DataServiceCM.GetInstance().ExecuteReader(query))
{
while (reader.Read())
{
target = _status == "係責承認中" ? reader.GetString(0).Trim()
: _status == "科責承認中" ? reader.GetString(1).Trim()
: _status == "部責承認中" ? reader.GetString(2).Trim()
: _status == "經管確認中" ? reader.GetString(3).Trim()
: _status == "經管檢查中" ? reader.GetString(4).Trim() : "";
applicant = reader.GetString(5).Trim();
reason = reader.GetString(6).Trim();
}
}
string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string text = _status == "係責承認中" ? string.Format("update TB_CM_DEBIT set d_status = N'科責承認中', d_sectapproval = 'Yes', d_sectdate = '{0}' where d_docno = '{1}'", now, _docno)
: _status == "科責承認中" ? string.Format("update TB_CM_DEBIT set d_status = N'部責承認中', d_divapproval = 'Yes', d_divdate = '{0}' where d_docno = '{1}'", now, _docno)
: _status == "部責承認中" ? string.Format("update TB_CM_DEBIT set d_status = N'經管確認中', d_deptapproval = 'Yes', d_deptdate = '{0}' where d_docno = '{1}'", now, _docno)
: _status == "經管檢查中" ? string.Format("update TB_CM_DEBIT set d_status = N'經管承認中', d_mcreviewerapproval = 'Yes', d_mcreviewerdate = '{0}' where d_docno = '{1}'", now, _docno)
: string.Format("update TB_CM_DEBIT set d_status = '申請處理完成', d_mcfinalapproval = 'Yes', d_mcfinaldate = '{0}' where d_docno = '{1}'", now, _docno);
DataServiceCM.GetInstance().ExecuteNonQuery(text);
string email = AdUtil.GetEmailByUsername(target, "kmhk.local");
string fromEmail = AdUtil.GetEmailByUsername(applicant, "kmhk.local");
if (_status == "部責承認中")
{
EformUtil.SendApprovalEmail(_docno, applicant, fromEmail, email, reason, "Debit Note Application Approval Required: " + _docno);
}
else
{
EformUtil.SendDebitNotificationEmail(_docno, applicant, fromEmail, email, "Received a Debit/Credit Note Application Form\n\nPlease check in Management Console");
}
DialogResult = DialogResult.OK;
}
private void btnSave_Click(object sender, EventArgs e)
{
string createdby = txtUser.Text.Trim();
string created = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string dept = txtDepartment.Text.Trim();
string company = txtCompany.Text.Trim();
string license = txtLicense.Text.Trim();
string dt = dtpDate.Value.ToString("yyyy/MM/dd");
string timeFrom = txtFrom.Text.Trim();
string timeTo = txtTo.Text.Trim();
string others = txtOthers.Text.Trim();
if (string.IsNullOrEmpty(license))
{
MessageBox.Show("請先輸入車牌號");
return;
}
string sectHead = UserUtil.GetSectionHead(UserUtil.GetSect(GlobalService.User));
string divHead = UserUtil.GetDivisionHead(UserUtil.GetDivision(GlobalService.User));
string adm1st = "Sammy Chow Chi To (周志滔)";
string adm2nd = "Sammy Chow Chi To (周志滔)";
string query = string.Format("insert into TB_ADM_FORM_PARK (ap_createdby, ap_created, ap_department, ap_company, ap_license, ap_date, ap_others, ap_sect, ap_div, ap_adm1st, ap_adm2nd, ap_from, ap_to)" +
" values (N'{0}', '{1}', N'{2}', N'{3}', '{4}', '{5}', N'{6}', N'{7}', N'{8}', N'{9}', N'{10}', '{11}', '{12}')", createdby, created, dept, company, license, dt, others, sectHead, divHead, adm1st, adm2nd, timeFrom, timeTo);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(sectHead, "kmhk.local"), "kmhk.local");
string text = "Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail("", GlobalService.User, from, to, body, "Approval Required - 訪客車位申請");
MessageBox.Show("Record has been saved.");
DialogResult = DialogResult.OK;
}
private void btnSave_Click(object sender, EventArgs e)
{
string createdby = txtUser.Text.Trim();
string created = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string department = txtDepartment.Text.Trim();
string china = ckbChina.Checked ? "Yes" : "No";
string taiwan = ckbTaiwan.Checked ? "Yes" : "No";
string india = ckbIndia.Checked ? "Yes" : "No";
string czech = ckbCzech.Checked ? "Yes" : "No";
string usa = ckbUsa.Checked ? "Yes" : "No";
string vietnam1 = ckbVietnam1.Checked ? "Yes" : "No";
string vietnam2 = ckbVietnam2.Checked ? "Yes" : "No";
string others = txtOthers.Text.Trim();
string date = dtpDate.Value.ToString("yyyy/MM/dd");
string reason = txtReason.Text.Trim();
string sectHead = UserUtil.GetSectionHead(UserUtil.GetSect(GlobalService.User));
string divHead = UserUtil.GetDivisionHead(UserUtil.GetDivision(GlobalService.User));
string adm1st = "Sammy Chow Chi To (周志滔)";
string adm2nd = "Sammy Chow Chi To (周志滔)";
string query = string.Format("insert into TB_ADM_FORM_VISA (av_createdby, av_created, av_department, av_china, av_taiwan, av_india, av_czech" +
", av_usa, av_vietnam1, av_vietnam2, av_others, av_indate, av_reason, av_sect, av_div, av_adm1st, av_adm2nd) values (N'{0}', '{1}', N'{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', N'{10}', '{11}', N'{12}', N'{13}', N'{14}', N'{15}', N'{16}')",
createdby, created, department, china, taiwan, india, czech, usa, vietnam1, vietnam2, others, date, reason, sectHead, divHead, adm1st, adm2nd);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(sectHead, "kmhk.local"), "kmhk.local");
string text = "Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail("", GlobalService.User, from, to, body, "Approval Required - 簽証申請");
MessageBox.Show("Record has been saved.");
DialogResult = DialogResult.OK;
}
public FormR3Application(string mode, string chaseno, string status)
{
InitializeComponent();
_mode = mode;
_chaseno = chaseno;
if (mode == "view")
{
cbType.Enabled = false;
cbR3Type.Enabled = false;
txtR3Id.KeyPress += new KeyPressEventHandler(KeyPressed);
txtRequest.KeyPress += new KeyPressEventHandler(KeyPressed);
txtReason.KeyPress += new KeyPressEventHandler(KeyPressed);
dtpStart.Enabled = false;
btnBrowse.Enabled = false;
btnUsers.Enabled = false;
LoadData();
}
else
{
cbType.SelectedIndex = 0;
cbR3Type.SelectedIndex = 0;
txtR3Id.PromptText = "可輸入多個R/3 用戶ID (請在ID後加上用戶姓名)\nR/3 用戶 ID 格式 : H+'xxxxxx'\n例: H123456 陳大文";
txtHead.Text = EformUtil.GetHead(GlobalService.User);
}
if (mode == "new")
{
ckbCancel.Visible = false;
}
else if (status == "上司承認中")
{
ckbCancel.Visible = true;
}
else
{
ckbCancel.Visible = false;
}
}
private void changeApproverToolStripMenuItem_Click(object sender, EventArgs e)
{
UserHeadForm form = new UserHeadForm("user");
if (form.ShowDialog() == DialogResult.OK)
{
switch (MessageBox.Show("Are you sure to change the approver to " + GlobalService.SelectedUserHead + "?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
foreach (DataGridViewRow row in dgvForm.SelectedRows)
{
string status = row.Cells[0].Value.ToString().Trim();
string refno = row.Cells[6].Value.ToString().Trim();
string query = status == "係責承認中" ? string.Format("update TB_ACC_OUTSTANDING set o_sect = N'{0}' where o_invoice = '{1}'", GlobalService.SelectedUserHead, refno)
: status == "科責承認中" ? string.Format("update TB_ACC_OUTSTANDING set o_div = N'{0}' where o_invoice = '{1}'", GlobalService.SelectedUserHead, refno)
: status == "部責承認中" ? string.Format("update TB_ACC_OUTSTANDING set o_dept = N'{0}' where o_invoice = '{1}'", GlobalService.SelectedUserHead, refno) : "";
if (query != "")
{
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.SelectedUserHead, "kmhk.local"), "kmhk.local");
string text = "Outstanding Slip Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail(refno, GlobalService.User, from, to, body, "Outstanding Slip");
}
}
MessageBox.Show("Record has been saved.");
LoadData();
break;
case DialogResult.No:
break;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string sectHead = UserUtil.GetSectionHead(UserUtil.GetSect(GlobalService.User));
string divHead = UserUtil.GetDivisionHead(UserUtil.GetDivision(GlobalService.User));
//string deptHead = "Ho Kin Hang(何健恒,Ken)";// UserUtil.GetDepartmentHead(UserUtil.GetDept(GlobalService.User));
string adm1st = "Sammy Chow Chi To (周志滔)";
string adm2nd = "Sammy Chow Chi To (周志滔)";
//string adm3rd = "Ho Kin Hang(何健恒,Ken)";//"Sammy Chow Chi To (周志滔)";
string createdby = txtUser.Text.Trim();
string created = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string department = txtDepartment.Text.Trim();
string fee = txtFee.Text.Trim();
string deptShared1 = txtDeptShared1.Text.Trim();
string deptShared2 = txtDeptShared2.Text.Trim();
string content = rtbContent.Text.Trim();
string query = string.Format("insert into TB_ADM_FORM_REPAIR (ar_created, ar_createdby, ar_department, ar_fee, ar_deptshared1, ar_deptshared2" +
", ar_content, ar_sect, ar_div, ar_adm1st, ar_adm2nd) values ('{0}', N'{1}', N'{2}', '{3}', N'{4}', N'{5}', N'{6}', N'{7}', N'{8}', N'{9}', N'{10}')", created, createdby, department, fee,
deptShared1, deptShared2, content, sectHead, divHead, adm1st, adm2nd);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(sectHead, "kmhk.local"), "kmhk.local");
string text = "Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail("", GlobalService.User, from, to, body, "Approval Required - 業務/修理依賴");
MessageBox.Show("Record has been saved.");
DialogResult = DialogResult.OK;
}
private void btnOK_Click(object sender, EventArgs e)
{
string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
if (!rbtnApprove.Checked && !rbtnReject.Checked)
{
DialogResult = DialogResult.Cancel;
}
else if (rbtnApprove.Checked)
{
string query = _status == "上司承認中" ? string.Format("update TB_FORM_R3 set r_approval = 'Yes', r_status = N'申請已發送' where r_chaseno = '{0}'", _chaseno)
: string.Format("update TB_FORM_R3 set r_cmapproval = 'Yes', r_cmappdate = '{0}', r_status = N'申請處理完成' where r_chaseno = '{1}'", now, _chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
if (_status == "上司承認中")
{
string mail = AdUtil.GetEmailByUsername(_applicant, "kmhk.local");
EformUtil.SendR3NotificationEmail(_chaseno, "R3申請", _applicant, mail, _title, EformUtil.GetR3Id(_chaseno), EformUtil.GetR3Request(_chaseno), EformUtil.GetR3Reason(_chaseno));
}
else
{
EformUtil.SendNotificationEmail(_chaseno, "R3申請", GlobalService.User, AdUtil.GetEmailByUsername(GlobalService.User, "kmhk.local"), "經管承認完了", "", 0, 0, null);
}
DialogResult = DialogResult.OK;
}
else
{
string query = _status == "上司承認中" ? string.Format("update TB_FORM_R3 set r_approval = 'Reject', r_status = N'上司已拒絕' where r_chaseno = '{0}'", _chaseno)
: string.Format("update TB_FORM_R3 set r_cmapproval = 'Reject', r_status = N'經管已拒絕' where r_chaseno = '{0}'", _chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
EformUtil.SendNotificationEmail(_chaseno, "R3申請", GlobalService.User, AdUtil.GetEmailByUsername(GlobalService.User, "kmhk.local"), "經管已拒絕", "", 0, 0, null);
DialogResult = DialogResult.OK;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string createdby = txtUser.Text.Trim();
string created = DateTime.Today.ToString("yyyy/MM/dd");
string department = txtDepartment.Text.Trim();
string remarks = txtRemarks.Text.Trim();
string sectHead = UserUtil.GetSectionHead(UserUtil.GetSect(GlobalService.User));
string divHead = UserUtil.GetDivisionHead(UserUtil.GetDivision(GlobalService.User));
string adm1st = "Sammy Chow Chi To (周志滔)";
string adm2nd = "Sammy Chow Chi To (周志滔)";
if (remarks.Contains("'"))
{
remarks = remarks.Replace("'", "''");
}
string query = string.Format("insert into TB_ADM_FORM_PURCHASE (ap_created, ap_createdby, ap_department, ap_remarks, ap_sect, ap_div, ap_adm1st, ap_adm2nd)" +
" values ('{0}', N'{1}', N'{2}', N'{3}', N'{4}', N'{5}', N'{6}', N'{7}')", created, createdby, department, remarks, sectHead, divHead, adm1st, adm2nd);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string text = "select top 1 ap_id from TB_ADM_FORM_PURCHASE order by ap_id desc";
int id = (int)DataServiceCM.GetInstance().ExecuteScalar(text);
foreach (DataGridViewRow row in dgvItems.Rows)
{
if (row.IsNewRow)
{
continue;
}
string item = row.Cells[0].Value.ToString().Trim();
string qty = row.Cells[1].Value.ToString().Trim();
string amount = row.Cells[2].Value.ToString().Trim();
if (item.Contains("'"))
{
item = item.Replace("'", "''");
}
string detailText = string.Format("insert into TB_ADM_FORM_PURCHASE_DETAIL (apd_ap_id, apd_item, apd_qty, apd_amount)" +
" values ('{0}', N'{1}', '{2}', '{3}')", id, item, qty, amount);
DataServiceCM.GetInstance().ExecuteNonQuery(detailText);
}
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(sectHead, "kmhk.local"), "kmhk.local");
string emailText = "Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + emailText + "</span></p>";
EformUtil.SendApprovalEmail("", GlobalService.User, from, to, body, "Approval Required - 月度購買依賴");
MessageBox.Show("Record has been saved.");
DialogResult = DialogResult.OK;
}
private void btnSave_Click(object sender, EventArgs e)
{
dgvItems.EndEdit();
string createdby = txtUser.Text.Trim();
string created = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string department = txtDepartment.Text.Trim();
string s1qty = dgvItems.Rows[0].Cells[1].Value.ToString();
double s1amt = Convert.ToDouble(dgvItems.Rows[0].Cells[2].Value);
string s2qty = dgvItems.Rows[1].Cells[1].Value.ToString();
double s2amt = Convert.ToDouble(dgvItems.Rows[1].Cells[2].Value);
string s3qty = dgvItems.Rows[2].Cells[1].Value.ToString();
double s3amt = Convert.ToDouble(dgvItems.Rows[2].Cells[2].Value);
string s4qty = dgvItems.Rows[3].Cells[1].Value.ToString();
double s4amt = Convert.ToDouble(dgvItems.Rows[3].Cells[2].Value);
string s5qty = dgvItems.Rows[4].Cells[1].Value.ToString();
double s5amt = Convert.ToDouble(dgvItems.Rows[4].Cells[2].Value);
string s6qty = dgvItems.Rows[5].Cells[1].Value.ToString();
double s6amt = Convert.ToDouble(dgvItems.Rows[5].Cells[2].Value);
string s7qty = dgvItems.Rows[6].Cells[1].Value.ToString();
double s7amt = Convert.ToDouble(dgvItems.Rows[6].Cells[2].Value);
string s8qty = dgvItems.Rows[7].Cells[1].Value.ToString();
double s8amt = Convert.ToDouble(dgvItems.Rows[7].Cells[2].Value);
string s9qty = dgvItems.Rows[8].Cells[1].Value.ToString();
double s9amt = Convert.ToDouble(dgvItems.Rows[8].Cells[2].Value);
string s10qty = dgvItems.Rows[9].Cells[1].Value.ToString();
double s10amt = Convert.ToDouble(dgvItems.Rows[9].Cells[2].Value);
double total = s1amt + s2amt + s3amt + s4amt + s5amt + s6amt + s7amt + s8amt + s9amt + s10amt;
string sectHead = UserUtil.GetSectionHead(UserUtil.GetSect(GlobalService.User));
string divHead = UserUtil.GetDivisionHead(UserUtil.GetDivision(GlobalService.User));
string adm1st = "Sammy Chow Chi To (周志滔)";
string adm2nd = "Sammy Chow Chi To (周志滔)";
string query = string.Format("insert into TB_ADM_FORM_STAMP (as_createdby, as_created, as_department, as_total, as_s1qty, as_s1amt, as_s2qty, as_s2amt" +
", as_s3qty, as_s3amt, as_s4qty, as_s4amt, as_s5qty, as_s5amt, as_s6qty, as_s6amt, as_s7qty, as_s7amt, as_s8qty, as_s8amt, as_s9qty, as_s9amt, as_s10qty, as_s10amt" +
", as_sect, as_div, as_adm1st, as_adm2nd) values (N'{0}', '{1}', N'{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', N'{24}', N'{25}', N'{26}', N'{27}')",
createdby, created, department, total, s1qty, s1amt, s2qty, s2amt, s3qty, s3amt, s4qty, s4amt, s5qty, s5amt, s6qty, s6amt, s7qty, s7amt, s8qty, s8amt, s9qty, s9amt, s10qty, s10amt, sectHead, divHead, adm1st, adm2nd);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(sectHead, "kmhk.local"), "kmhk.local");
string text = "Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail("", GlobalService.User, from, to, body, "Approval Required - 購買郵票依賴");
MessageBox.Show("Record has been saved.");
DialogResult = DialogResult.OK;
}
public FormITApplication(string mode, string type, string chaseno, string status)
{
InitializeComponent();
txtUser.Text = GlobalService.User;
string head = EformUtil.GetHead(GlobalService.User);
txtHead.Text = head;
//rtbContent.Select();
txtTitle.Select();
_mode = mode;
_type = type;
_chaseno = chaseno;
this.Text = "IT Application";
dtpEnd.Value = dtpStart.Value.AddDays(7);
Application.Idle += new EventHandler(Application_Idle);
if (mode == "view")
{
if (chaseno.StartsWith("IT-0"))
{
LoadOriginalData(type, chaseno);
}
else
{
LoadData(type, chaseno);
}
txtUser.KeyPress += new KeyPressEventHandler(Keypressed);
rtbContent.KeyPress += new KeyPressEventHandler(Keypressed);
dtpStart.Enabled = false;
dtpEnd.Enabled = false;
ckbSupport.Enabled = false;
ckbComment.Enabled = false;
txtHead.KeyPress += new KeyPressEventHandler(Keypressed);
btnApplicant.Visible = false;
btnUsers.Visible = false;
txtTitle.KeyPress += new KeyPressEventHandler(Keypressed);
}
if (mode == "new")
{
ckbCancel.Visible = false;
}
else if (status == "申請已發送" && (type == "IT技術支援" || type == "IT意見箱"))
{
ckbCancel.Visible = true;
}
else if (status == "上司承認中")
{
ckbCancel.Visible = true;
}
else
{
ckbCancel.Visible = false;
}
}
private void SaveData()
{
if (string.IsNullOrEmpty(txtTitle.Text))
{
MessageBox.Show("請輸入申請項目主題");
return;
}
rtbContent.SaveFile("temp.rtf");
FileStream stream = new FileStream("temp.rtf", FileMode.Open, FileAccess.Read);
int size = Convert.ToInt32(stream.Length);
Byte[] rtf = new Byte[size];
stream.Read(rtf, 0, size);
string user = txtUser.Text.Trim();
string category = ckbSupport.Checked ? "IT技術支援" : ckbComment.Checked ? "IT意見箱" : "IT綜合申請";
string start = dtpStart.Value.ToString("yyyy/MM/dd");
string end = dtpEnd.Value.ToString("yyyy/MM/dd");
string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string head = txtHead.Text.Trim();
string chaseno = GetLatestChaseno();
string title = txtTitle.Text.Trim();
if (title.Contains("'"))
{
title = title.Replace("'", "''");
}
if (category != "IT技術支援" && category != "IT意見箱")
{
string query = string.Format("insert into TB_FORM (f_chaseno, f_type, f_content, f_start, f_end, f_created, f_createdby, f_status, f_applicant, f_approver, f_title)" +
" values ('{0}', N'{1}', @Content, '{2}', '{3}', '{4}', N'{5}', N'{6}', N'{7}', N'{8}', N'{9}')", chaseno, category, start, end, now, GlobalService.User, "上司承認中", user, head, title);
SqlCommand cmd = new SqlCommand(query, DataService.GetInstance().Connection);
SqlParameter param = new SqlParameter("@Content", SqlDbType.Image, rtf.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rtf);
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
//Send Email
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(head, "kmhk.local"), "kmhk.local");
string text = "IT Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
EformUtil.SendApprovalEmail(chaseno, GlobalService.User, from, to, body, txtTitle.Text.Trim());
}
else
{
string query = string.Format("insert into TB_FORM (f_chaseno, f_type, f_content, f_start, f_end, f_createdby, f_created, f_status, f_applicant, f_approver, f_title)" +
" values ('{0}', N'{1}', @Content, '{2}', '{3}', N'{4}', N'{5}', N'{6}', N'{7}', N'{8}', N'{9}')", chaseno, category, start, end, GlobalService.User, now, "申請已發送", user, "---", title);
SqlCommand cmd = new SqlCommand(query, DataService.GetInstance().Connection);
SqlParameter param = new SqlParameter("@Content", SqlDbType.Image, rtf.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rtf);
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
string email = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
EformUtil.SendReceivedEmail(chaseno, email, txtTitle.Text.Trim());
EformUtil.SendNotificationEmail(chaseno, category, GlobalService.User, email, txtTitle.Text.Trim(), rtbContent.Rtf, rtbContent.Width, rtbContent.Height, rtbContent);
}
DialogResult = DialogResult.OK;
}
private void btnUpload_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == DialogResult.OK)
{
DataTable table = ImportExcel2007.TranslateToTable(ofd.FileName);
List <int> invoiceIdList = new List <int>();
foreach (DataRow row in table.Rows)
{
string invoice = row.ItemArray[0].ToString().Trim();
string vendor = row.ItemArray[1].ToString().Trim();
string acccode = row.ItemArray[3].ToString().Trim();
string costcentre = row.ItemArray[4].ToString().Trim();
string amount = row.ItemArray[10].ToString().Trim();
string approval = row.ItemArray[11].ToString().Trim();
if (approval == "Yes")
{
int id = GetInvoiceId(invoice);
string status = GetInvoiceStatus(invoice);
string query = status == "會計處理中" ? string.Format("update TB_ACC_OUTSTANDING_DETAIL set od_staffapproval = 'Yes' where od_o_id = '{0}' and od_accountcode = '{1}'" +
" and od_costcentre = '{2}' and od_amount = '{3}'", id, acccode, costcentre, amount) : string.Format("update TB_ACC_OUTSTANDING_DETAIL set od_divapproval = 'Yes'" +
" where od_o_id = '{0}' and od_accountcode = '{1}' and od_costcentre = '{2}' and od_amount = '{3}'", id, acccode, costcentre, amount);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
invoiceIdList.Add(id);
}
}
invoiceIdList = invoiceIdList.Distinct().ToList();
string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
foreach (int item in invoiceIdList)
{
string status = GetInvoiceStatusById(item);
string invoice = GetInvoiceById(item);
string applicant = AccUtil.GetApplicant(invoice);
string div = AccUtil.GetDivisionApprover(invoice);
string staff = AccUtil.GetAccStaff(invoice);
string acc = AccUtil.GetAccApprover(invoice);
if (status == "會計處理中")
{
if (IsAllItemApprovedByStaff(item))
{
string query = string.Format("update TB_ACC_OUTSTANDING set o_status = N'會計承認中', o_staffapproval = 'Yes', o_staffapprovaldate = '{0}' where o_id = '{1}'", now, item);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
EformUtil.SendApprovalEmail(_invoice, applicant, AdUtil.GetEmailByUsername(applicant, "kmhk.local"), AdUtil.GetEmailByUsername(acc, "kmhk.local"), "", "Outstanding Slip - " + invoice);
}
}
if (status == "會計承認中")
{
if (IsAllItemApprovedByAcc(item))
{
string query = string.Format("update TB_ACC_OUTSTANDING set o_status = N'申請處理完成', o_accapproval = 'Yes', o_accapprovaldate = '{0}' where o_id = '{1}'", now, item);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
EformUtil.SendFinishedEmail(_invoice, acc, AdUtil.GetEmailByUsername(acc, "kmhk.local"), AdUtil.GetEmailByUsername(applicant, "kmhk.local"), "Outstanding Slip Application Finished - " + invoice, "You Outstanding Slip Application has been finished.");
}
}
}
MessageBox.Show("Record has been uploaded.");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dgvPermission.Rows.Count == 0)
{
MessageBox.Show("No record found.");
return;
}
dgvPermission.EndEdit();
if (!IsDataValid(dgvPermission))
{
MessageBox.Show("Invalid input found.");
return;
}
string applicant = DataUtil.GetApplicant(GlobalService.ChaseNo);
string head = DataUtil.GetHead(applicant);
string approval = DataUtil.IsItemApproved(GlobalService.ChaseNo) ? "Yes" : "No";
string strApprovalDate = DataUtil.GetApprovalDate(GlobalService.ChaseNo);
string st = approval == "Yes" ? "I.T處理中" : "上司承認中";
string chaseno = DataUtil.GetPermissionChaseNo();
foreach (DataGridViewRow row in dgvPermission.Rows)
{
if (row.IsNewRow)
{
continue;
}
string item = row.Cells[0].Value.ToString();
string user = row.Cells[1].Value.ToString();
string start = row.Cells[2].Value.ToString();
string status = row.Cells[3].Value.ToString();
string remarks = row.Cells[4].Value == null? "": row.Cells[4].Value.ToString();
string assigned = row.Cells[5].Value.ToString().Trim();
//string query = string.Format("insert into TB_FORM_PERMISSION (p_type, p_user, p_item, p_created, p_createdby, p_start, p_remarks, p_chaseno, p_approver, p_approval, p_refno, p_applicant, p_status, p_handledby)" +
// " values ('{0}', N'{1}', N'{2}', '{3}', N'{4}', '{5}', N'{6}', '{7}', N'{8}', '{9}', '{10}', N'{11}', N'{12}', N'{13}')", status, user, item, DateTime.Today.ToString("yyyy/MM/dd"), GlobalService.Creator, start, remarks, chaseno, head, approval, GlobalService.ChaseNo, GlobalService.Creator, st, assigned);
string query = string.Format("insert into TB_FORM_PERMISSION (p_type, p_user, p_item, p_created, p_createdby, p_start, p_remarks, p_chaseno, p_approver, p_approval, p_refno, p_applicant, p_status, p_handledby, p_itapproval, p_approvaldate)" +
" values ('{0}', N'{1}', N'{2}', '{3}', N'{4}', '{5}', N'{6}', '{7}', N'{8}', '{9}', '{10}', N'{11}', N'{12}', N'{13}', N'{14}', N'{15}')",
status, user, item, DateTime.Today.ToString("yyyy/MM/dd"), GlobalService.Creator, start, remarks, chaseno, head, approval, GlobalService.ChaseNo, GlobalService.Creator, st, assigned, UserUtil.ItManagerName(), strApprovalDate);
DataService.GetInstance().ExecuteNonQuery(query);
}
GlobalService.SavedForm = "permission";
/*if (st == "上司承認中")
* {
* string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User, "kmhk.local"), "kmhk.local");
*
* string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(head, "kmhk.local"), "kmhk.local");
*
* string text = "IT Application Approval required. Please click <a href=\"\\\\kdthk-dm1\\project\\it system\\MyCloud Beta\\KDTHK-DM-SP.application\">HERE</a> to approval process.";
* string body = "<p><span style=\"font-family: Calibri;\">" + text + "</span></p>";
* //EformUtil.SendApprovalEmail(chaseno, from, to, body);
* }*/
if (approval == "No")
{
string from = AdUtil.GetEmailByUsername(applicant, "kmhk.local");
string to = AdUtil.GetEmailByUsername(head, "kmhk.local");
EformUtil.SendApprovalEmail(GlobalService.ChaseNo, from, to, "Approval Required for 權限及軟件安裝", "權限及軟件安裝", applicant);
}
if (SavedEvent != null)
{
SavedEvent(this, new EventArgs());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string appType = cbAppType.SelectedItem.ToString().Trim();
string reason = txtReason.Text.Trim();
string vendorType = cbVendorType.SelectedItem.ToString().Trim();
string vendorCode = txtVendorCode.Text.Trim();
string vendorName = txtVendorName.Text.Trim();
string addr1 = txtAddr1.Text.Trim();
string addr2 = txtAddr2.Text.Trim();
string addr3 = txtAddr3.Text.Trim();
string person = txtPerson.Text.Trim();
string phone = txtPhone.Text.Trim();
string email = txtEmail.Text.Trim();
string currency = cbCurrency.SelectedItem.ToString().Trim();
string payterm = txtPayterm.Text.Trim();
string fob = cbFob.SelectedItem.ToString().Trim();
if (reason.Contains("'"))
{
reason = reason.Replace("'", "''");
}
if (vendorName.Contains("'"))
{
vendorName = vendorName.Replace("'", "''");
}
if (addr1.Contains("'"))
{
addr1 = addr1.Replace("'", "''");
}
if (addr2.Contains("'"))
{
addr2 = addr2.Replace("'", "''");
}
if (addr3.Contains("'"))
{
addr3 = addr3.Replace("'", "''");
}
string divHead = "Ho Kin Hang(何健恒,Ken)"; //UserUtil.GetDiv(GlobalService.User);
string cm1st = "Ho Kin Hang(何健恒,Ken)"; //"Ng Wai Kwan(吳蕙君,Wendy)";
string cm2nd = "Ho Kin Hang(何健恒,Ken)"; //"Li Yuen Yan(李婉茵,Sharon)";
string cm3rd = "Ho Kin Hang(何健恒,Ken)"; //"Leung Wai Yip(梁偉業,Philip)";
string cm4th = "Ho Kin Hang(何健恒,Ken)"; //"Hara Masatoshi(原雅俊)";
string attachment = "";
string query = string.Format("insert into TB_ACC_VENDOR (v_type, v_reason, v_vendortype, v_code, v_name, v_addr1, v_addr2, v_addr3, v_person, v_phone, v_email" +
", v_currency, v_payterm, v_fob, v_attachment, v_created, v_createdby, v_div, v_cm1st, v_cm2nd, v_cm3rd, v_cm4th) values ('{0}', N'{1}', N'{2}', '{3}', N'{4}', N'{5}', N'{6}'" +
", N'{7}', N'{8}', '{9}', '{10}', '{11}', '{12}', '{13}', N'{14}', '{15}', N'{16}', N'{17}', N'{18}', N'{19}', N'{20}', N'{21}')", appType, reason, vendorType, vendorCode, vendorName,
addr1, addr2, addr3, person, phone, email, currency, payterm, fob, "", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), GlobalService.User, divHead, cm1st, cm2nd, cm3rd, cm4th);
DataServiceCM.GetInstance().ExecuteNonQuery(query);
EformUtil.SendApprovalEmail("", GlobalService.User, AdUtil.GetEmailByUsername(GlobalService.User, "kmhk.local"), AdUtil.GetEmailByUsername(divHead, "kmhk.local"), "", "Vendor Master Application - " + appType);
DialogResult = DialogResult.OK;
}
private void btnSave_Click(object sender, EventArgs e)
{
string title = cbCategory.Text + " " + cbR3Category.Text;
string startdate = dtpStart.Value.ToString("yyyy/MM/dd");
string comment = txtComment.Text.Trim();
string attachment = txtAttachment.Text.Trim();
string category = cbCategory.Text.Trim();
string r3Category = cbR3Category.Text.Trim();
string status = cbStatus.Text == "Completed" ? "經管承認中" : "IT處理中";
string applicant = DataUtil.GetApplicant(GlobalService.ChaseNo);
string head = DataUtil.GetHead(applicant);
string chaseno = DataUtil.GetR3Chaseno();
string cmApprover = txtCmApprover.Text.Trim();
//string itApprover = "Chan Fai Lung(陳輝龍,Onyx)";
string itApprover = UserUtil.ItUserName2();
if (cbStatus.Text == "Cancel")
{
string query = string.Format("delete from TB_FORM where f_chaseno = '{0}'", GlobalService.ChaseNo);
DataService.GetInstance().ExecuteNonQuery(query);
}
else
{
string filePath = "";
if (attachment != "")
{
string filename = Path.GetFileName(attachment);
string directory = @"\\kdthk-dm1\project\kdthk-dm\Forms\R3 Application\IT Attachments\";
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
File.Copy(attachment, directory + filename, true);
filePath = directory + filename;
}
string query = string.Format("insert into TB_FORM_R3 (r_chaseno, r_status, r_applicant, r_created, r_title, r_category, r_type, r_content, r_start" +
", r_approver, r_approval, r_cmapprover, r_cmapproval, r_itapprover, r_itapproval, r_itattachment, r_itcomment, r_refno) values ('{0}', N'{1}', N'{2}'" +
", '{3}', N'{4}', N'{5}', '{6}', N'{7}', '{8}', N'{9}', '{10}', N'{11}', '{12}', N'{13}', N'{14}', N'{15}', N'{16}', '{17}')", chaseno, status, applicant, DateTime.Today.ToString("yyyy/MM/dd"),
title, category, r3Category, "", startdate, head, "Yes", cmApprover, "No", itApprover, "Yes", filePath, comment, GlobalService.ChaseNo);
DataService.GetInstance().ExecuteNonQuery(query);
string from = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(GlobalService.User));
string to = AdUtil.GetEmailByUserId(AdUtil.GetUserIdByUsername(cmApprover));
EformUtil.SendR3ApprovalEmail(title, comment, filePath, "", from, to, GlobalService.User);
}
if (SavedEvent != null)
{
SavedEvent(this, new EventArgs());
}
}
