private void AssetMovementReportBtn_Click(object sender, EventArgs e) { frmAssetMovementReport rpt = new frmAssetMovementReport(); rpt.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง rpt.Asset_Sys = strAssetMovementId; rpt.ShowDialog(); }
private void CreateAsset_Btn_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to movement asset " + txtAssetNo.Text.Trim() + " yes/no?", "Asset Management Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { Tr = Conn.BeginTransaction(); try { string sqlSaveStHead; Sbd = new StringBuilder(); Sbd.Remove(0, Sbd.Length); Sbd.Append("UPDATE Asset "); Sbd.Append("SET Owner = @To_Owner,"); Sbd.Append("Base = @To_Base,"); Sbd.Append("Location = @To_Location,"); Sbd.Append("Asset_Status = @To_Status, "); Sbd.Append("Modified_By = @Modified_By, "); Sbd.Append("Modified_Date = @Modified_Date, "); Sbd.Append("Amend = @Amend "); Sbd.Append("WHERE Asset_No_System = @Asset_No_System"); sqlSaveStHead = Sbd.ToString(); Cmd.Parameters.Clear(); Cmd.Transaction = Tr; Cmd.CommandText = sqlSaveStHead; Cmd.Parameters.Add("@To_Owner", SqlDbType.NChar).Value = cboOwner.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Base", SqlDbType.NChar).Value = cboBase.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Location", SqlDbType.NChar).Value = cboLocation.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Status", SqlDbType.NChar).Value = cboStatus.SelectedValue.ToString(); Cmd.Parameters.Add("@Asset_No_System", SqlDbType.NVarChar).Value = txt_Sys_Asset.Text.Trim(); Cmd.Parameters.Add("@Modified_Date", SqlDbType.DateTime).Value = DateTime.Now; Cmd.Parameters.Add("@Modified_By", SqlDbType.NChar).Value = userId; Cmd.Parameters.Add("@Amend", SqlDbType.Int).Value = Convert.ToInt64(txtAmend.Text.Trim()) + 1; Cmd.ExecuteNonQuery(); // Insert to movement for first time created asset Sbd = new StringBuilder(); Sbd.Remove(0, Sbd.Length); Sbd.Append("INSERT INTO Asset_Movement "); Sbd.Append("(Asset_Movement_Id,"); Sbd.Append("Asset_No_System,"); Sbd.Append("Asset_No,"); Sbd.Append("Fixed_Asset_No,"); Sbd.Append("From_Owner,"); Sbd.Append("From_Base,"); Sbd.Append("From_Location,"); Sbd.Append("From_Status,"); Sbd.Append("Remarks,"); Sbd.Append("MovementDate,"); Sbd.Append("Movement_By,"); Sbd.Append("To_Owner,"); Sbd.Append("To_Base,"); Sbd.Append("To_Location,"); Sbd.Append("To_Status,"); Sbd.Append("RequestBy,"); Sbd.Append("Asste_Move_RunId) "); Sbd.Append("VALUES "); Sbd.Append("(@Asset_Movement_Id,"); Sbd.Append("@Asset_No_System,"); Sbd.Append("@Asset_No,"); Sbd.Append("@Fixed_Asset_No,"); Sbd.Append("@From_Owner,"); Sbd.Append("@From_Base,"); Sbd.Append("@From_Location,"); Sbd.Append("@From_Status,"); Sbd.Append("@Remarks,"); Sbd.Append("@MovementDate,"); Sbd.Append("@Movement_By,"); Sbd.Append("@To_Owner,"); Sbd.Append("@To_Base,"); Sbd.Append("@To_Location,"); Sbd.Append("@To_Status,"); Sbd.Append("@RequestBy,"); Sbd.Append("@Asste_Move_RunId) "); sqlSaveStHead = Sbd.ToString(); Cmd.Parameters.Clear(); Cmd.Transaction = Tr; Cmd.CommandText = sqlSaveStHead; Cmd.Parameters.Add("@Asset_Movement_Id", SqlDbType.NVarChar).Value = txtAssetMovementId.Text.Trim(); Cmd.Parameters.Add("@Asset_No_System", SqlDbType.NVarChar).Value = txt_Sys_Asset.Text.Trim(); Cmd.Parameters.Add("@Asset_No", SqlDbType.NVarChar).Value = txtAssetNo.Text.Trim(); Cmd.Parameters.Add("@Fixed_Asset_No", SqlDbType.NVarChar).Value = txtFixAssetNo.Text.Trim(); Cmd.Parameters.Add("@From_Owner", SqlDbType.NChar).Value = cboOwner.SelectedValue.ToString(); Cmd.Parameters.Add("@From_Base", SqlDbType.NChar).Value = cboBase.SelectedValue.ToString(); Cmd.Parameters.Add("@From_Location", SqlDbType.NChar).Value = cboLocation.SelectedValue.ToString(); Cmd.Parameters.Add("@From_Status", SqlDbType.NChar).Value = cboStatus.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Owner", SqlDbType.NChar).Value = cboOwner.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Base", SqlDbType.NChar).Value = cboBase.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Location", SqlDbType.NChar).Value = cboLocation.SelectedValue.ToString(); Cmd.Parameters.Add("@To_Status", SqlDbType.NChar).Value = cboStatus.SelectedValue.ToString(); Cmd.Parameters.Add("@Remarks", SqlDbType.NVarChar).Value = txtRemarksForMoveTo.Text.Trim(); Cmd.Parameters.Add("@MovementDate", SqlDbType.DateTime).Value = DateTime.Now; Cmd.Parameters.Add("@Movement_By", SqlDbType.NChar).Value = userId; Cmd.Parameters.Add("@Asste_Move_RunId", SqlDbType.Int).Value = AssetMovementId; Cmd.Parameters.Add("@RequestBy", SqlDbType.NChar).Value = cboRequestBy.SelectedValue.ToString(); Cmd.ExecuteNonQuery(); MessageBox.Show("Record asset successfully", "Asset Management Message", MessageBoxButtons.OK, MessageBoxIcon.None); Tr.Commit(); DialogResult dlg = MessageBox.Show("ต้องการพิมพ์ เอกสาร Asset Movement หรือไม่!!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlg == DialogResult.OK) { frmAssetMovementReport rpt = new frmAssetMovementReport(); rpt.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง rpt.Asset_Sys = txt_Sys_Asset.Text.Trim(); rpt.ShowDialog(); } Close(); } catch (Exception ex) { MessageBox.Show("Unable to record asset" + ex.Message, "Asset Management Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); Tr.Rollback(); } } }