public String insert(XcustPorReqHeaderIntAll p) { String sql = "", chk = ""; try { //if (p.OrpChtNum.Equals("")) //{ // return ""; //} //p.RowNumber = selectMaxRowNumber(p.YearId); //p.Active = "1"; sql = "Insert Into " + xCPRHIA.table + "(" + xCPRHIA.ATTRIBUTE1 + "," + xCPRHIA.ATTRIBUTE_DATE1 + "," + xCPRHIA.ATTRIBUTE_TIMESTAMP1 + "," + xCPRHIA.Batch_ID + "," + xCPRHIA.Description + "," + xCPRHIA.ENTER_BY + "," + xCPRHIA.import_source + "," + xCPRHIA.ATTRIBUTE_CATEGORY + "," + xCPRHIA.PO_NUMBER + "," + xCPRHIA.PROCESS_FLAG + "," + xCPRHIA.PR_APPROVER + "," + xCPRHIA.PR_STATAUS + "," + xCPRHIA.Requisitioning_BU + "," + xCPRHIA.Requisition_Number + ") " + "Values('" + p.ATTRIBUTE1 + "','" + p.ATTRIBUTE_DATE1 + "','" + p.ATTRIBUTE_TIMESTAMP1 + "','" + p.Batch_ID + "','" + p.Description + "','" + p.ENTER_BY + "','" + p.import_source + "','" + p.ATTRIBUTE_CATEGORY + "','" + p.PO_NUMBER + "','" + p.PROCESS_FLAG + "','" + p.PR_APPROVER + "','" + p.PR_STATAUS + "','" + p.Requisitioning_BU + "','" + p.Requisition_Number + "') "; chk = conn.ExecuteNonQuery(sql, "kfc_po"); //chk = p.RowNumber; //chk = p.Code; } catch (Exception ex) { //MessageBox.Show("Error " + ex.ToString(), "insert Doctor"); } return(chk); }
private void initConfig() { xCPRHIA = new XcustPorReqHeaderIntAll(); xCPRHIA.ATTRIBUTE1 = "ATTRIBUTE1"; xCPRHIA.ATTRIBUTE_DATE1 = "ATTRIBUTE_DATE1"; xCPRHIA.ATTRIBUTE_TIMESTAMP1 = "ATTRIBUTE_TIMESTAMP1"; xCPRHIA.Batch_ID = "Batch_ID"; xCPRHIA.Description = "Description"; xCPRHIA.ENTER_BY = "ENTER_BY"; xCPRHIA.import_source = "import_source"; xCPRHIA.ATTRIBUTE_CATEGORY = "ATTRIBUTE_CATEGORY"; xCPRHIA.PO_NUMBER = "PO_NUMBER"; xCPRHIA.PROCESS_FLAG = "PROCESS_FLAG"; xCPRHIA.PR_APPROVER = "PR_APPROVER"; xCPRHIA.PR_STATAUS = "PR_STATAUS"; xCPRHIA.Requisitioning_BU = "Requisitioning_BU"; xCPRHIA.Requisition_Number = "Requisition_Number"; xCPRHIA.pkField = ""; xCPRHIA.table = "xcust_por_req_header_int_all"; }
private void insertXcustPorReqHeaderIntAll(DataRow row, String date, String time) {//row[dc].ToString().Trim(). XcustPorReqHeaderIntAll xCPRHIA = new XcustPorReqHeaderIntAll(); xCPRHIA.ATTRIBUTE1 = row[xCLFPTDB.xCLFPT.PO_NUMBER].ToString().Trim(); xCPRHIA.ATTRIBUTE_DATE1 = date; xCPRHIA.ATTRIBUTE_TIMESTAMP1 = date + " " + time; xCPRHIA.Batch_ID = ""; xCPRHIA.Description = row[xCLFPTDB.xCLFPT.LINE_NUMBER].ToString().Trim(); xCPRHIA.ENTER_BY = ""; xCPRHIA.import_source = ""; xCPRHIA.ATTRIBUTE_CATEGORY = ""; xCPRHIA.PO_NUMBER = row[xCLFPTDB.xCLFPT.PO_NUMBER].ToString().Trim(); xCPRHIA.PROCESS_FLAG = "N"; xCPRHIA.PR_APPROVER = ""; xCPRHIA.PR_STATAUS = ""; xCPRHIA.Requisitioning_BU = ""; xCPRHIA.Requisition_Number = ""; xCPRHIADB.insert(xCPRHIA); }