public bool UpdateCostReport(OsPayOffData pod) { using (TransactionScope tran = new TransactionScope()) using (SqlConnection conn = new SqlConnection(ConnectionString)) { try { conn.Open(); SqlCommand cmd = new SqlCommand(updSql, conn); cmd = parametersSqlDbTypeA(cmd); cmd = parametersValueA(cmd, pod); if (TryExecute(conn, cmd) < 0) { return(false); } } catch (SqlException sqle) { MessageBox.Show("SQLエラー errorno " + Convert.ToString(sqle.Number) + " " + sqle.Message); conn.Close(); return(false); } conn.Close(); tran.Complete(); } return(true); }
//--------------------------------------------------------// // Method //--------------------------------------------------------// public object Clone() { OsPayOffData cloneData = new OsPayOffData(); cloneData.OsPayOffID = this.OsPayOffID; cloneData.ReportDate = this.ReportDate; cloneData.OfficeCode = this.OfficeCode; cloneData.Department = this.Department; cloneData.ItemCode = this.ItemCode; cloneData.Item = this.Item; cloneData.TaskCode = this.TaskCode; cloneData.Cost = this.Cost; cloneData.LeaderMCode = this.LeaderMCode; cloneData.AdminCheck = this.AdminCheck; cloneData.AdminCode = this.AdminCode; cloneData.DirectorCheck = this.DirectorCheck; cloneData.PresidentCheck = this.PresidentCheck; cloneData.ACheckDate = this.ACheckDate; cloneData.DCheckDate = this.DCheckDate; cloneData.PCheckDate = this.PCheckDate; cloneData.SlipNo = this.SlipNo; cloneData.CostReportID = this.CostReportID; cloneData.Unit = this.Unit; cloneData.ContractForm = this.ContractForm; cloneData.CloseInf = this.CloseInf; cloneData.Publisher = this.Publisher; cloneData.TaskName = this.TaskName; cloneData.LeaderMName = this.LeaderMName; cloneData.Customer = this.Customer; cloneData.ContTitle = this.ContTitle; cloneData.ReportCheck = this.ReportCheck; return(cloneData); }
private SqlCommand parametersValueA(SqlCommand cmd, OsPayOffData pod) { cmd.Parameters["@slip"].Value = pod.SlipNo; // 0 cmd.Parameters["@tCod"].Value = pod.TaskCode; // 1 cmd.Parameters["@oCod"].Value = pod.OfficeCode; // 2 cmd.Parameters["@dept"].Value = pod.Department; // 3 cmd.Parameters["@qty"].Value = 1; // 8 cmd.Parameters["@cost"].Value = pod.Cost; // 9 cmd.Parameters["@lCod"].Value = pod.LeaderMCode; // 15 return(cmd); }
public OsPayOffData SelectOsPayOff(int slipNo) { SqlHandling sh = new SqlHandling("D_OsPayOff"); DataTable dt = sh.SelectAllData("WHERE SlipNo = " + slipNo); if (dt == null || dt.Rows.Count < 1) { return(null); } OsPayOffData pod = new OsPayOffData(dt.Rows[0]); return(pod); }