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);
}
