工事管理システム製品化対応

            strcmd.Append(",DepositAmount");

            strcmd.Append(",DepositAmountCash");

            strcmd.Append(",DepositAmountBill");

            strcmd.Append(",DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");

            strcmd.Append(",DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");

            strcmd.Append(" FROM DepositData");

            return strcmd.ToString();

                wrk.DepositAmount = long.Parse(objwrk[(int)ColumnName.DepositAmount].ToString());

                wrk.DepositAmountCash = long.Parse(objwrk[(int)ColumnName.DepositAmountCash].ToString());

                wrk.DepositAmountBill = long.Parse(objwrk[(int)ColumnName.DepositAmountBill].ToString());

                wrk.EntryDate = DateTime.Parse(objwrk[(int)ColumnName.EntryDate].ToString());

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)ColumnName.UpdateDate].ToString());

                strcmd.Append(" ,ConfirmationPersonCode");

                strcmd.Append(" ,DATE_FORMAT(ConfirmationDate, '%Y/%m/%d')");

                strcmd.Append(" ,ConfirmationEndFlg");

                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");

                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");

                strcmd.Append(" FROM DepositDataDetail");

                wrk.ConfirmationPersonCode = int.Parse(objwrk[(int)NameColumn.ConfirmationPersonCode].ToString());

                wrk.ConfirmationDate = DateTime.Parse(objwrk[(int)NameColumn.ConfirmationDate].ToString());

                wrk.ConfirmationEndFlg = int.Parse(objwrk[(int)NameColumn.ConfirmationEndFlg].ToString());

                wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.EntryDate].ToString());

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)NameColumn.UpdateDate].ToString());