public DataBaseResultSet SaveTallyMaster <T>(T objData) where T : class, IModel, new() { TallyMaster obj = objData as TallyMaster; string sQuery = "sprocTallyMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("TallyTag", "TallyTag", 10, GenericDataType.String, ParameterDirection.Input, obj.TallyTag)); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("VAT", "VAT", 5, GenericDataType.String, ParameterDirection.Input, obj.VAT)); list.Add(SqlConnManager.GetConnParameters("TallyLedger", "TallyLedger", 100, GenericDataType.String, ParameterDirection.Input, obj.TallyLedger)); list.Add(SqlConnManager.GetConnParameters("TallyVATLedger", "TallyVATLedger", 100, GenericDataType.String, ParameterDirection.Input, obj.TallyVATLedger)); list.Add(SqlConnManager.GetConnParameters("TallyClass", "TallyClass", 100, GenericDataType.String, ParameterDirection.Input, obj.TallyClass)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveT_MstAccountMaster <T>(T objData) where T : class, IModel, new() { T_MstAccountMaster obj = objData as T_MstAccountMaster; string sQuery = "sprocT_MstAccountMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("AccountName", "AccountName", 100, GenericDataType.String, ParameterDirection.Input, obj.AccountName)); list.Add(SqlConnManager.GetConnParameters("Address", "Address", 100, GenericDataType.String, ParameterDirection.Input, obj.Address)); list.Add(SqlConnManager.GetConnParameters("Place", "Place", 100, GenericDataType.String, ParameterDirection.Input, obj.Place)); list.Add(SqlConnManager.GetConnParameters("OpeningBalance", "OpeningBalance", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpeningBalance)); list.Add(SqlConnManager.GetConnParameters("TypeDrCr", "TypeDrCr", 10, GenericDataType.String, ParameterDirection.Input, obj.TypeDrCr)); list.Add(SqlConnManager.GetConnParameters("GroupId", "GroupId", 10, GenericDataType.String, ParameterDirection.Input, obj.GroupId)); list.Add(SqlConnManager.GetConnParameters("GroupCode", "GroupCode", 20, GenericDataType.String, ParameterDirection.Input, obj.GroupCode)); list.Add(SqlConnManager.GetConnParameters("PanCardNo", "PanCardNo", 10, GenericDataType.String, ParameterDirection.Input, obj.PanCardNo)); list.Add(SqlConnManager.GetConnParameters("FCC", "FCC", 50, GenericDataType.String, ParameterDirection.Input, obj.FCC)); list.Add(SqlConnManager.GetConnParameters("Range", "Range", 50, GenericDataType.String, ParameterDirection.Input, obj.Range)); list.Add(SqlConnManager.GetConnParameters("DivI", "DivI", 50, GenericDataType.String, ParameterDirection.Input, obj.DivI)); list.Add(SqlConnManager.GetConnParameters("CommI", "CommI", 50, GenericDataType.String, ParameterDirection.Input, obj.CommI)); list.Add(SqlConnManager.GetConnParameters("BST", "BST", 50, GenericDataType.String, ParameterDirection.Input, obj.BST)); list.Add(SqlConnManager.GetConnParameters("CST", "CST", 50, GenericDataType.String, ParameterDirection.Input, obj.CST)); list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Packing)); list.Add(SqlConnManager.GetConnParameters("Checking", "Checking", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Checking)); list.Add(SqlConnManager.GetConnParameters("Other", "Other", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Other)); list.Add(SqlConnManager.GetConnParameters("Insurance", "Insurance", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Insurance)); list.Add(SqlConnManager.GetConnParameters("ADath", "ADath", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ADath)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 10, GenericDataType.String, ParameterDirection.Input, DateTime.Now)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveConfig <T>(T objData) where T : class, IModel, new() { Config obj = objData as Config; string sQuery = "sprocConfigInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("DfltVariable", "DfltVariable", 50, GenericDataType.String, ParameterDirection.Input, obj.DfltVariable)); list.Add(SqlConnManager.GetConnParameters("DfltValue", "DfltValue", 50, GenericDataType.String, ParameterDirection.Input, obj.DfltValue)); list.Add(SqlConnManager.GetConnParameters("USERCODE", "USERCODE", 8, GenericDataType.Long, ParameterDirection.Input, obj.USERCODE)); list.Add(SqlConnManager.GetConnParameters("CUSER", "CUSER", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUSER)); list.Add(SqlConnManager.GetConnParameters("CDATETIME", "CDATETIME", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDATETIME)); list.Add(SqlConnManager.GetConnParameters("EUSER", "EUSER", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUSER)); list.Add(SqlConnManager.GetConnParameters("EDATETIME", "EDATETIME", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDATETIME)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveT_TranCash <T>(T objData) where T : class, IModel, new() { T_TranCash obj = objData as T_TranCash; string sQuery = "sprocT_TranCashInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("TranBankId", "TranBankId", 8, GenericDataType.Long, ParameterDirection.Input, obj.TranBankId)); list.Add(SqlConnManager.GetConnParameters("VoucherNo", "VoucherNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.VoucherNo)); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId)); list.Add(SqlConnManager.GetConnParameters("AmountType", "AmountType", 10, GenericDataType.String, ParameterDirection.Input, obj.AmountType)); list.Add(SqlConnManager.GetConnParameters("VoucherDate", "VoucherDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VoucherDate)); list.Add(SqlConnManager.GetConnParameters("ChequeNo", "ChequeNo", 50, GenericDataType.String, ParameterDirection.Input, obj.ChequeNo)); list.Add(SqlConnManager.GetConnParameters("BankId", "BankId", 8, GenericDataType.Long, ParameterDirection.Input, obj.BankId)); list.Add(SqlConnManager.GetConnParameters("PartyId", "PartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyId)); list.Add(SqlConnManager.GetConnParameters("NoOfDay", "NoOfDay", 4, GenericDataType.Int, ParameterDirection.Input, obj.NoOfDay)); list.Add(SqlConnManager.GetConnParameters("Place", "Place", 50, GenericDataType.String, ParameterDirection.Input, obj.Place)); list.Add(SqlConnManager.GetConnParameters("BankName", "BankName", 100, GenericDataType.String, ParameterDirection.Input, obj.BankName)); list.Add(SqlConnManager.GetConnParameters("Description", "Description", 500, GenericDataType.String, ParameterDirection.Input, obj.Description)); list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveT_MstCompany <T>(T objData) where T : class, IModel, new() { T_MstCompany obj = objData as T_MstCompany; string sQuery = "sprocT_MstCompanyInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyId)); list.Add(SqlConnManager.GetConnParameters("FinancialYearId", "FinancialYearId", 4, GenericDataType.Int, ParameterDirection.Input, obj.FinancialYearId)); list.Add(SqlConnManager.GetConnParameters("CompanyName", "CompanyName", 100, GenericDataType.String, ParameterDirection.Input, obj.CompanyName)); list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 100, GenericDataType.String, ParameterDirection.Input, obj.Add1)); list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 100, GenericDataType.String, ParameterDirection.Input, obj.Add2)); list.Add(SqlConnManager.GetConnParameters("Place", "Place", 50, GenericDataType.String, ParameterDirection.Input, obj.Place)); list.Add(SqlConnManager.GetConnParameters("PhoneNo", "PhoneNo", 50, GenericDataType.String, ParameterDirection.Input, obj.PhoneNo)); list.Add(SqlConnManager.GetConnParameters("PhoneNo1", "PhoneNo1", 50, GenericDataType.String, ParameterDirection.Input, obj.PhoneNo1)); list.Add(SqlConnManager.GetConnParameters("MobileNo", "MobileNo", 50, GenericDataType.String, ParameterDirection.Input, obj.MobileNo)); list.Add(SqlConnManager.GetConnParameters("PanNo", "PanNo", 15, GenericDataType.String, ParameterDirection.Input, obj.PanNo)); list.Add(SqlConnManager.GetConnParameters("ECCNo", "ECCNo", 50, GenericDataType.String, ParameterDirection.Input, obj.ECCNo)); list.Add(SqlConnManager.GetConnParameters("TdsNo", "TdsNo", 50, GenericDataType.String, ParameterDirection.Input, obj.TdsNo)); list.Add(SqlConnManager.GetConnParameters("AccountNo", "AccountNo", 50, GenericDataType.String, ParameterDirection.Input, obj.AccountNo)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now)); list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveBranchStock <T>(T objData) where T : class, IModel, new() { BranchStock obj = objData as BranchStock; string sQuery = "sprocBranchStockInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("BranchName", "BranchName", 50, GenericDataType.String, ParameterDirection.Input, obj.BranchName)); list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode)); list.Add(SqlConnManager.GetConnParameters("PartyPrdCode", "PartyPrdCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyPrdCode)); list.Add(SqlConnManager.GetConnParameters("ProductName", "ProductName", 50, GenericDataType.String, ParameterDirection.Input, obj.ProductName)); list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 50, GenericDataType.String, ParameterDirection.Input, obj.Packing)); list.Add(SqlConnManager.GetConnParameters("CompanyTag", "CompanyTag", 50, GenericDataType.String, ParameterDirection.Input, obj.CompanyTag)); list.Add(SqlConnManager.GetConnParameters("RackID", "RackID", 50, GenericDataType.String, ParameterDirection.Input, obj.RackID)); list.Add(SqlConnManager.GetConnParameters("TStk", "TStk", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TStk)); list.Add(SqlConnManager.GetConnParameters("Scheme", "Scheme", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Scheme)); list.Add(SqlConnManager.GetConnParameters("SQty", "SQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SQty)); list.Add(SqlConnManager.GetConnParameters("SFQty", "SFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SFQty)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("BranchCode", "BranchCode", 10, GenericDataType.String, ParameterDirection.Input, obj.BranchCode)); list.Add(SqlConnManager.GetConnParameters("UDateTime", "UDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SavePreFormat <T>(T objData) where T : class, IModel, new() { PreFormat obj = objData as PreFormat; string sQuery = "sprocPreFormatInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo)); list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate)); list.Add(SqlConnManager.GetConnParameters("CustomerCode", "CustomerCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CustomerCode)); list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode)); list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode)); list.Add(SqlConnManager.GetConnParameters("Qty", "Qty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Qty)); list.Add(SqlConnManager.GetConnParameters("Remark", "Remark", 50, GenericDataType.String, ParameterDirection.Input, obj.Remark)); list.Add(SqlConnManager.GetConnParameters("ReminderTag", "ReminderTag", 10, GenericDataType.String, ParameterDirection.Input, obj.ReminderTag)); list.Add(SqlConnManager.GetConnParameters("ReminderOn", "ReminderOn", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReminderOn)); list.Add(SqlConnManager.GetConnParameters("ReminderUpTo", "ReminderUpTo", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReminderUpTo)); list.Add(SqlConnManager.GetConnParameters("Disc", "Disc", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Disc)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveAdjDetail <T>(T objData) where T : class, IModel, new() { AdjDetail obj = objData as AdjDetail; string sQuery = "sprocAdjDetailInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("CodeName", "CodeName", 30, GenericDataType.String, ParameterDirection.Input, obj.CodeName)); list.Add(SqlConnManager.GetConnParameters("CodeRef", "CodeRef", 8, GenericDataType.Long, ParameterDirection.Input, obj.CodeRef)); list.Add(SqlConnManager.GetConnParameters("BillTag", "BillTag", 20, GenericDataType.String, ParameterDirection.Input, obj.BillTag)); list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType)); list.Add(SqlConnManager.GetConnParameters("BillCredit", "BillCredit", 10, GenericDataType.String, ParameterDirection.Input, obj.BillCredit)); list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 1, GenericDataType.String, ParameterDirection.Input, obj.BillSeries)); list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo)); list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate)); list.Add(SqlConnManager.GetConnParameters("PurBillNo", "PurBillNo", 10, GenericDataType.String, ParameterDirection.Input, obj.PurBillNo)); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount)); list.Add(SqlConnManager.GetConnParameters("RcptAmount", "RcptAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptAmount)); list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveT_ErrorDesc <T>(T objData) where T : class, IModel, new() { T_ErrorDesc obj = objData as T_ErrorDesc; string sQuery = "sprocT_ErrorDescInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("ErrorId", "ErrorId", 8, GenericDataType.Long, ParameterDirection.Input, obj.ErrorId)); list.Add(SqlConnManager.GetConnParameters("CategoryId", "CategoryId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CategoryId)); list.Add(SqlConnManager.GetConnParameters("PageCode", "PageCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.PageCode)); list.Add(SqlConnManager.GetConnParameters("MethodCode", "MethodCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.MethodCode)); list.Add(SqlConnManager.GetConnParameters("EventCode", "EventCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.EventCode)); list.Add(SqlConnManager.GetConnParameters("ErrorLineNo", "ErrorLineNo", 4, GenericDataType.Int, ParameterDirection.Input, obj.ErrorLineNo)); list.Add(SqlConnManager.GetConnParameters("MethodTrace", "MethodTrace", 100, GenericDataType.String, ParameterDirection.Input, obj.MethodTrace)); list.Add(SqlConnManager.GetConnParameters("EmpNo", "EmpNo", 10, GenericDataType.String, ParameterDirection.Input, obj.EmpNo)); list.Add(SqlConnManager.GetConnParameters("ClientIPAddress", "ClientIPAddress", 30, GenericDataType.String, ParameterDirection.Input, obj.ClientIPAddress)); list.Add(SqlConnManager.GetConnParameters("PageName", "PageName", 50, GenericDataType.String, ParameterDirection.Input, obj.PageName)); list.Add(SqlConnManager.GetConnParameters("MethodName", "MethodName", 50, GenericDataType.String, ParameterDirection.Input, obj.MethodName)); list.Add(SqlConnManager.GetConnParameters("ErrorMsg", "ErrorMsg", 500, GenericDataType.String, ParameterDirection.Input, obj.ErrorMsg)); list.Add(SqlConnManager.GetConnParameters("ErrorType", "ErrorType", 50, GenericDataType.String, ParameterDirection.Input, obj.ErrorType)); list.Add(SqlConnManager.GetConnParameters("ErrorDate", "ErrorDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ErrorDate)); list.Add(SqlConnManager.GetConnParameters("ErrorData", "ErrorData", -1, GenericDataType.String, ParameterDirection.Input, obj.ErrorData)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveAutoSetup <T>(T objData) where T : class, IModel, new() { AutoSetup obj = objData as AutoSetup; string sQuery = "sprocAutoSetupInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 10, GenericDataType.String, ParameterDirection.Input, obj.EntryTag)); list.Add(SqlConnManager.GetConnParameters("ReportName", "ReportName", 100, GenericDataType.String, ParameterDirection.Input, obj.ReportName)); list.Add(SqlConnManager.GetConnParameters("MailTime", "MailTime", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MailTime)); list.Add(SqlConnManager.GetConnParameters("MailToID", "MailToID", 200, GenericDataType.String, ParameterDirection.Input, obj.MailToID)); list.Add(SqlConnManager.GetConnParameters("MailCCID", "MailCCID", 200, GenericDataType.String, ParameterDirection.Input, obj.MailCCID)); list.Add(SqlConnManager.GetConnParameters("MailBCCID", "MailBCCID", 200, GenericDataType.String, ParameterDirection.Input, obj.MailBCCID)); list.Add(SqlConnManager.GetConnParameters("SName", "SName", 10, GenericDataType.String, ParameterDirection.Input, obj.SName)); list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 10, GenericDataType.String, ParameterDirection.Input, obj.Phone1)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveCompanyDetail <T>(T objData) where T : class, IModel, new() { CompanyDetail obj = objData as CompanyDetail; string sQuery = "sprocCompanyDetailInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("CompanyCode", "CompanyCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyCode)); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("CashDiscount", "CashDiscount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashDiscount)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveShiftMaster <T>(T objData) where T : class, IModel, new() { ShiftMaster obj = objData as ShiftMaster; string sQuery = "sprocShiftMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("ShiftName", "ShiftName", 50, GenericDataType.String, ParameterDirection.Input, obj.ShiftName)); list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo)); list.Add(SqlConnManager.GetConnParameters("ShiftDate", "ShiftDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ShiftDate)); list.Add(SqlConnManager.GetConnParameters("OpCash", "OpCash", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpCash)); list.Add(SqlConnManager.GetConnParameters("CashReceipt", "CashReceipt", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashReceipt)); list.Add(SqlConnManager.GetConnParameters("ReceiptVoucher", "ReceiptVoucher", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReceiptVoucher)); list.Add(SqlConnManager.GetConnParameters("CashReturn", "CashReturn", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashReturn)); list.Add(SqlConnManager.GetConnParameters("CashPayment", "CashPayment", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashPayment)); list.Add(SqlConnManager.GetConnParameters("PaymentVoucher", "PaymentVoucher", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PaymentVoucher)); list.Add(SqlConnManager.GetConnParameters("ExtraAmount", "ExtraAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ExtraAmount)); list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount)); list.Add(SqlConnManager.GetConnParameters("ShiftMess", "ShiftMess", 100, GenericDataType.String, ParameterDirection.Input, obj.ShiftMess)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveT_TranPurchaseOrder <T>(T objData) where T : class, IModel, new() { T_TranPurchaseOrder obj = objData as T_TranPurchaseOrder; string sQuery = "sprocT_TranPurchaseOrderInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("TranPurchaseOrderId", "TranPurchaseOrderId", 10, GenericDataType.String, ParameterDirection.Input, obj.TranPurchaseOrderId)); list.Add(SqlConnManager.GetConnParameters("ConfirmationNo", "ConfirmationNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ConfirmationNo)); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId)); list.Add(SqlConnManager.GetConnParameters("CurrDate", "CurrDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CurrDate)); list.Add(SqlConnManager.GetConnParameters("PartyId", "PartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyId)); list.Add(SqlConnManager.GetConnParameters("WeaverCode", "WeaverCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.WeaverCode)); list.Add(SqlConnManager.GetConnParameters("QualityCode", "QualityCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.QualityCode)); list.Add(SqlConnManager.GetConnParameters("BrokerCode", "BrokerCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.BrokerCode)); list.Add(SqlConnManager.GetConnParameters("ThanCount", "ThanCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.ThanCount)); list.Add(SqlConnManager.GetConnParameters("Rate", "Rate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Rate)); list.Add(SqlConnManager.GetConnParameters("CD", "CD", 50, GenericDataType.String, ParameterDirection.Input, obj.CD)); list.Add(SqlConnManager.GetConnParameters("Side", "Side", 50, GenericDataType.String, ParameterDirection.Input, obj.Side)); list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Packing)); list.Add(SqlConnManager.GetConnParameters("PendingThan", "PendingThan", 4, GenericDataType.Int, ParameterDirection.Input, obj.PendingThan)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now)); list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveDiseaseMaster <T>(T objData) where T : class, IModel, new() { DiseaseMaster obj = objData as DiseaseMaster; string sQuery = "sprocDiseaseMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("DiseaseCode", "DiseaseCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DiseaseCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("DiseaseName", "DiseaseName", 50, GenericDataType.String, ParameterDirection.Input, obj.DiseaseName)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveReceivePayment <T>(T objData) where T : class, IModel, new() { ReceivePayment obj = objData as ReceivePayment; string sQuery = "sprocReceivePaymentInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 30, GenericDataType.String, ParameterDirection.Input, obj.EntryTag)); list.Add(SqlConnManager.GetConnParameters("RefNo", "RefNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RefNo)); list.Add(SqlConnManager.GetConnParameters("EntryDate", "EntryDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EntryDate)); list.Add(SqlConnManager.GetConnParameters("ChequeNo", "ChequeNo", 10, GenericDataType.String, ParameterDirection.Input, obj.ChequeNo)); list.Add(SqlConnManager.GetConnParameters("ChequeDate", "ChequeDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ChequeDate)); list.Add(SqlConnManager.GetConnParameters("AccountCode1", "AccountCode1", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode1)); list.Add(SqlConnManager.GetConnParameters("AccountCode2", "AccountCode2", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode2)); list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount)); list.Add(SqlConnManager.GetConnParameters("RcptMess", "RcptMess", 100, GenericDataType.String, ParameterDirection.Input, obj.RcptMess)); list.Add(SqlConnManager.GetConnParameters("ReconDate", "ReconDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ReconDate)); list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveOrderDetail <T>(T objData) where T : class, IModel, new() { OrderDetail obj = objData as OrderDetail; string sQuery = "sprocOrderDetailInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("BillTag", "BillTag", 20, GenericDataType.String, ParameterDirection.Input, obj.BillTag)); list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType)); list.Add(SqlConnManager.GetConnParameters("BillCredit", "BillCredit", 10, GenericDataType.String, ParameterDirection.Input, obj.BillCredit)); list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 1, GenericDataType.String, ParameterDirection.Input, obj.BillSeries)); list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo)); list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate)); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("ChallanNo", "ChallanNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ChallanNo)); list.Add(SqlConnManager.GetConnParameters("ChallanDate", "ChallanDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ChallanDate)); list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 8, GenericDataType.String, ParameterDirection.Input, obj.EntryTag)); list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode)); list.Add(SqlConnManager.GetConnParameters("CompanyCode", "CompanyCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyCode)); list.Add(SqlConnManager.GetConnParameters("BatchCode", "BatchCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.BatchCode)); list.Add(SqlConnManager.GetConnParameters("MRP", "MRP", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MRP)); list.Add(SqlConnManager.GetConnParameters("BatchNo", "BatchNo", 15, GenericDataType.String, ParameterDirection.Input, obj.BatchNo)); list.Add(SqlConnManager.GetConnParameters("Expiry", "Expiry", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.Expiry)); list.Add(SqlConnManager.GetConnParameters("Qty", "Qty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Qty)); list.Add(SqlConnManager.GetConnParameters("FQty", "FQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.FQty)); list.Add(SqlConnManager.GetConnParameters("ConversionUnit", "ConversionUnit", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ConversionUnit)); list.Add(SqlConnManager.GetConnParameters("Rate", "Rate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Rate)); list.Add(SqlConnManager.GetConnParameters("HalfScheme", "HalfScheme", 3, GenericDataType.String, ParameterDirection.Input, obj.HalfScheme)); list.Add(SqlConnManager.GetConnParameters("Scheme", "Scheme", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Scheme)); list.Add(SqlConnManager.GetConnParameters("SchemeRs", "SchemeRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SchemeRs)); list.Add(SqlConnManager.GetConnParameters("SplDisc", "SplDisc", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplDisc)); list.Add(SqlConnManager.GetConnParameters("SplDiscRs", "SplDiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplDiscRs)); list.Add(SqlConnManager.GetConnParameters("Disc", "Disc", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Disc)); list.Add(SqlConnManager.GetConnParameters("DiscRs", "DiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DiscRs)); list.Add(SqlConnManager.GetConnParameters("Inclusive", "Inclusive", 3, GenericDataType.String, ParameterDirection.Input, obj.Inclusive)); list.Add(SqlConnManager.GetConnParameters("VatOn", "VatOn", 5, GenericDataType.String, ParameterDirection.Input, obj.VatOn)); list.Add(SqlConnManager.GetConnParameters("Vat", "Vat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Vat)); list.Add(SqlConnManager.GetConnParameters("VatRs", "VatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.VatRs)); list.Add(SqlConnManager.GetConnParameters("AdVat", "AdVat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVat)); list.Add(SqlConnManager.GetConnParameters("AdVatRs", "AdVatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVatRs)); list.Add(SqlConnManager.GetConnParameters("NetRate", "NetRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetRate)); list.Add(SqlConnManager.GetConnParameters("VatOnFree", "VatOnFree", 3, GenericDataType.String, ParameterDirection.Input, obj.VatOnFree)); list.Add(SqlConnManager.GetConnParameters("NetCostRate", "NetCostRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetCostRate)); list.Add(SqlConnManager.GetConnParameters("NetAmount", "NetAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetAmount)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveOrderMaster <T>(T objData) where T : class, IModel, new() { OrderMaster obj = objData as OrderMaster; string sQuery = "sprocOrderMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("BillTag", "BillTag", 20, GenericDataType.String, ParameterDirection.Input, obj.BillTag)); list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType)); list.Add(SqlConnManager.GetConnParameters("BillCredit", "BillCredit", 10, GenericDataType.String, ParameterDirection.Input, obj.BillCredit)); list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 1, GenericDataType.String, ParameterDirection.Input, obj.BillSeries)); list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo)); list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate)); list.Add(SqlConnManager.GetConnParameters("PurBillNo", "PurBillNo", 10, GenericDataType.String, ParameterDirection.Input, obj.PurBillNo)); list.Add(SqlConnManager.GetConnParameters("PurBillDate", "PurBillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.PurBillDate)); list.Add(SqlConnManager.GetConnParameters("CustomerCode", "CustomerCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CustomerCode)); list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode)); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("SalesmanCode", "SalesmanCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.SalesmanCode)); list.Add(SqlConnManager.GetConnParameters("VatInRate", "VatInRate", 3, GenericDataType.String, ParameterDirection.Input, obj.VatInRate)); list.Add(SqlConnManager.GetConnParameters("GrossAmount", "GrossAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.GrossAmount)); list.Add(SqlConnManager.GetConnParameters("SchemeRs", "SchemeRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SchemeRs)); list.Add(SqlConnManager.GetConnParameters("SplDiscRs", "SplDiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplDiscRs)); list.Add(SqlConnManager.GetConnParameters("DiscPer", "DiscPer", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DiscPer)); list.Add(SqlConnManager.GetConnParameters("DiscRs", "DiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DiscRs)); list.Add(SqlConnManager.GetConnParameters("VatPer", "VatPer", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.VatPer)); list.Add(SqlConnManager.GetConnParameters("VatRs", "VatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.VatRs)); list.Add(SqlConnManager.GetConnParameters("AdVatPer", "AdVatPer", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVatPer)); list.Add(SqlConnManager.GetConnParameters("AdVatRs", "AdVatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVatRs)); list.Add(SqlConnManager.GetConnParameters("CrRs", "CrRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrRs)); list.Add(SqlConnManager.GetConnParameters("OtherAdj", "OtherAdj", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OtherAdj)); list.Add(SqlConnManager.GetConnParameters("RndOff", "RndOff", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RndOff)); list.Add(SqlConnManager.GetConnParameters("NetAmount", "NetAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetAmount)); list.Add(SqlConnManager.GetConnParameters("RateTag", "RateTag", 10, GenericDataType.String, ParameterDirection.Input, obj.RateTag)); list.Add(SqlConnManager.GetConnParameters("OrdRef", "OrdRef", 20, GenericDataType.String, ParameterDirection.Input, obj.OrdRef)); list.Add(SqlConnManager.GetConnParameters("ModOfDespatch", "ModOfDespatch", 20, GenericDataType.String, ParameterDirection.Input, obj.ModOfDespatch)); list.Add(SqlConnManager.GetConnParameters("RRNo", "RRNo", 20, GenericDataType.String, ParameterDirection.Input, obj.RRNo)); list.Add(SqlConnManager.GetConnParameters("NoOfPack", "NoOfPack", 20, GenericDataType.String, ParameterDirection.Input, obj.NoOfPack)); list.Add(SqlConnManager.GetConnParameters("DespDate", "DespDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.DespDate)); list.Add(SqlConnManager.GetConnParameters("SplInst", "SplInst", 50, GenericDataType.String, ParameterDirection.Input, obj.SplInst)); list.Add(SqlConnManager.GetConnParameters("RcptAmount", "RcptAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptAmount)); list.Add(SqlConnManager.GetConnParameters("MiscPndAmount", "MiscPndAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MiscPndAmount)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveAccountMaster <T>(T objData) where T : class, IModel, new() { AccountMaster obj = objData as AccountMaster; string sQuery = "sprocAccountMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("AccountName", "AccountName", 50, GenericDataType.String, ParameterDirection.Input, obj.AccountName)); list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1)); list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 50, GenericDataType.String, ParameterDirection.Input, obj.Add2)); list.Add(SqlConnManager.GetConnParameters("Add3", "Add3", 50, GenericDataType.String, ParameterDirection.Input, obj.Add3)); list.Add(SqlConnManager.GetConnParameters("Add4", "Add4", 50, GenericDataType.String, ParameterDirection.Input, obj.Add4)); list.Add(SqlConnManager.GetConnParameters("CityCode", "CityCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CityCode)); list.Add(SqlConnManager.GetConnParameters("ContactPerson", "ContactPerson", 50, GenericDataType.String, ParameterDirection.Input, obj.ContactPerson)); list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone1)); list.Add(SqlConnManager.GetConnParameters("Phone2", "Phone2", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone2)); list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email)); list.Add(SqlConnManager.GetConnParameters("DLNo1", "DLNo1", 50, GenericDataType.String, ParameterDirection.Input, obj.DLNo1)); list.Add(SqlConnManager.GetConnParameters("DLNo2", "DLNo2", 50, GenericDataType.String, ParameterDirection.Input, obj.DLNo2)); list.Add(SqlConnManager.GetConnParameters("VatTin", "VatTin", 50, GenericDataType.String, ParameterDirection.Input, obj.VatTin)); list.Add(SqlConnManager.GetConnParameters("VatDate", "VatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VatDate)); list.Add(SqlConnManager.GetConnParameters("CSTVat", "CSTVat", 50, GenericDataType.String, ParameterDirection.Input, obj.CSTVat)); list.Add(SqlConnManager.GetConnParameters("CSTVatDate", "CSTVatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CSTVatDate)); list.Add(SqlConnManager.GetConnParameters("CashDiscount", "CashDiscount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashDiscount)); list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 20, GenericDataType.String, ParameterDirection.Input, obj.BillSeries)); list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType)); list.Add(SqlConnManager.GetConnParameters("AccountType", "AccountType", 50, GenericDataType.String, ParameterDirection.Input, obj.AccountType)); list.Add(SqlConnManager.GetConnParameters("GroupCode", "GroupCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.GroupCode)); list.Add(SqlConnManager.GetConnParameters("VisitDay", "VisitDay", 21, GenericDataType.String, ParameterDirection.Input, obj.VisitDay)); list.Add(SqlConnManager.GetConnParameters("InfoID", "InfoID", 10, GenericDataType.String, ParameterDirection.Input, obj.InfoID)); list.Add(SqlConnManager.GetConnParameters("OpBalAmount", "OpBalAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpBalAmount)); list.Add(SqlConnManager.GetConnParameters("OpSetAmount", "OpSetAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpSetAmount)); list.Add(SqlConnManager.GetConnParameters("BalAmount", "BalAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.BalAmount)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("ChequeName", "ChequeName", 50, GenericDataType.String, ParameterDirection.Input, obj.ChequeName)); list.Add(SqlConnManager.GetConnParameters("LBT", "LBT", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.LBT)); list.Add(SqlConnManager.GetConnParameters("LBTNo", "LBTNo", 50, GenericDataType.String, ParameterDirection.Input, obj.LBTNo)); list.Add(SqlConnManager.GetConnParameters("LBTCat", "LBTCat", 50, GenericDataType.String, ParameterDirection.Input, obj.LBTCat)); list.Add(SqlConnManager.GetConnParameters("DueDay", "DueDay", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DueDay)); list.Add(SqlConnManager.GetConnParameters("MailFormat", "MailFormat", 50, GenericDataType.String, ParameterDirection.Input, obj.MailFormat)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public void GetListT_PrimKeyValues <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListT_PrimKeyValues"; T_PrimKeyValues objData = objFilter as T_PrimKeyValues; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, objData.PrimKeyTable)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData); }
public void GetListMiscRcptPmt <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListMiscRcptPmt"; MiscRcptPmt objData = objFilter as MiscRcptPmt; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RcptCode", "RcptCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.RcptCode)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillMiscRcptPmtDataFromReader, ref listData); }
public void GetListXDetail <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListXDetail"; XDetail objData = objFilter as XDetail; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, objData.RecNo)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillXDetailDataFromReader, ref listData); }
public void GetAllListProduct <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "sprocGetAllListProduct"; ProductMaster objData = objFilter as ProductMaster; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.ProductCode)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillProductMasterDataFromReader, ref listData); }
public void GetListT_ErrorDesc <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListT_ErrorDesc"; T_ErrorDesc objData = objFilter as T_ErrorDesc; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("ErrorId", "ErrorId", 8, GenericDataType.Long, ParameterDirection.Input, objData.ErrorId)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData); }
public void GetListT_MstAccount <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListT_MstAccount"; T_MstAccount objData = objFilter as T_MstAccount; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("", "", 0, GenericDataType.Int, ParameterDirection.Input, objData.AccountId)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData); }
public DataBaseResultSet SavePrintFormat <T>(T objData) where T : class, IModel, new() { PrintFormat obj = objData as PrintFormat; string sQuery = "sprocPrintFormatInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("LabelType", "LabelType", 50, GenericDataType.String, ParameterDirection.Input, obj.LabelType)); list.Add(SqlConnManager.GetConnParameters("OprtSys", "OprtSys", 50, GenericDataType.String, ParameterDirection.Input, obj.OprtSys)); list.Add(SqlConnManager.GetConnParameters("FormatName", "FormatName", 50, GenericDataType.String, ParameterDirection.Input, obj.FormatName)); list.Add(SqlConnManager.GetConnParameters("PrinterName", "PrinterName", 50, GenericDataType.String, ParameterDirection.Input, obj.PrinterName)); list.Add(SqlConnManager.GetConnParameters("TxtType", "TxtType", 50, GenericDataType.String, ParameterDirection.Input, obj.TxtType)); list.Add(SqlConnManager.GetConnParameters("SampleTxt", "SampleTxt", 200, GenericDataType.String, ParameterDirection.Input, obj.SampleTxt)); list.Add(SqlConnManager.GetConnParameters("FPrefix", "FPrefix", 50, GenericDataType.String, ParameterDirection.Input, obj.FPrefix)); list.Add(SqlConnManager.GetConnParameters("FldName", "FldName", 50, GenericDataType.String, ParameterDirection.Input, obj.FldName)); list.Add(SqlConnManager.GetConnParameters("FSufix", "FSufix", 50, GenericDataType.String, ParameterDirection.Input, obj.FSufix)); list.Add(SqlConnManager.GetConnParameters("PrntFormat", "PrntFormat", 50, GenericDataType.String, ParameterDirection.Input, obj.PrntFormat)); list.Add(SqlConnManager.GetConnParameters("PosX", "PosX", 8, GenericDataType.Long, ParameterDirection.Input, obj.PosX)); list.Add(SqlConnManager.GetConnParameters("PosY", "PosY", 8, GenericDataType.Long, ParameterDirection.Input, obj.PosY)); list.Add(SqlConnManager.GetConnParameters("PWidth", "PWidth", 8, GenericDataType.Long, ParameterDirection.Input, obj.PWidth)); list.Add(SqlConnManager.GetConnParameters("PHeight", "PHeight", 8, GenericDataType.Long, ParameterDirection.Input, obj.PHeight)); list.Add(SqlConnManager.GetConnParameters("FntName", "FntName", 50, GenericDataType.String, ParameterDirection.Input, obj.FntName)); list.Add(SqlConnManager.GetConnParameters("FntStyle", "FntStyle", 50, GenericDataType.String, ParameterDirection.Input, obj.FntStyle)); list.Add(SqlConnManager.GetConnParameters("FntBold", "FntBold", 3, GenericDataType.String, ParameterDirection.Input, obj.FntBold)); list.Add(SqlConnManager.GetConnParameters("FntItalic", "FntItalic", 3, GenericDataType.String, ParameterDirection.Input, obj.FntItalic)); list.Add(SqlConnManager.GetConnParameters("FntStrikout", "FntStrikout", 3, GenericDataType.String, ParameterDirection.Input, obj.FntStrikout)); list.Add(SqlConnManager.GetConnParameters("FntUnderLine", "FntUnderLine", 3, GenericDataType.String, ParameterDirection.Input, obj.FntUnderLine)); list.Add(SqlConnManager.GetConnParameters("FntSize", "FntSize", 8, GenericDataType.Long, ParameterDirection.Input, obj.FntSize)); list.Add(SqlConnManager.GetConnParameters("FntColor", "FntColor", 8, GenericDataType.Long, ParameterDirection.Input, obj.FntColor)); list.Add(SqlConnManager.GetConnParameters("AcrossLbl", "AcrossLbl", 8, GenericDataType.Long, ParameterDirection.Input, obj.AcrossLbl)); list.Add(SqlConnManager.GetConnParameters("PgLbl", "PgLbl", 8, GenericDataType.Long, ParameterDirection.Input, obj.PgLbl)); list.Add(SqlConnManager.GetConnParameters("DuplicateLbl", "DuplicateLbl", 3, GenericDataType.String, ParameterDirection.Input, obj.DuplicateLbl)); list.Add(SqlConnManager.GetConnParameters("PgTopMargin", "PgTopMargin", 8, GenericDataType.Long, ParameterDirection.Input, obj.PgTopMargin)); list.Add(SqlConnManager.GetConnParameters("PgLeftMargin", "PgLeftMargin", 8, GenericDataType.Long, ParameterDirection.Input, obj.PgLeftMargin)); list.Add(SqlConnManager.GetConnParameters("LblVerticalGap", "LblVerticalGap", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblVerticalGap)); list.Add(SqlConnManager.GetConnParameters("LblHorizontalGap", "LblHorizontalGap", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblHorizontalGap)); list.Add(SqlConnManager.GetConnParameters("LblWidth", "LblWidth", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblWidth)); list.Add(SqlConnManager.GetConnParameters("LblHeight", "LblHeight", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblHeight)); list.Add(SqlConnManager.GetConnParameters("NoOfLine", "NoOfLine", 8, GenericDataType.Long, ParameterDirection.Input, obj.NoOfLine)); list.Add(SqlConnManager.GetConnParameters("GapLine", "GapLine", 8, GenericDataType.Long, ParameterDirection.Input, obj.GapLine)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("PrintStyle", "PrintStyle", 50, GenericDataType.String, ParameterDirection.Input, obj.PrintStyle)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public void GetListT_MstCompanyForDropDown <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListT_MstCompanyDropDown"; T_MstCompany objData = objFilter as T_MstCompany; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, objData.CompanyId)); list.Add(SqlConnManager.GetConnParameters("FinancialYearId", "FinancialYearId", 4, GenericDataType.Int, ParameterDirection.Input, objData.FinancialYearId)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillMstCompanyDropDownDataFromReader, ref listData); }
public void GetListT_MstQuality <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListT_MstQuality"; T_MstQuality objData = objFilter as T_MstQuality; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("QualityCode", "QualityCode", 4, GenericDataType.Int, ParameterDirection.Input, objData.QualityCode)); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Long, ParameterDirection.Input, objData.CompanyId)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData); }
public void GetListT_TranPurchaseOrder <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListT_TranPurchaseOrder"; T_TranPurchaseOrder objData = objFilter as T_TranPurchaseOrder; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("TranPurchaseOrderId", "TranPurchaseOrderId", 10, GenericDataType.String, ParameterDirection.Input, objData.TranPurchaseOrderId)); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Long, ParameterDirection.Input, objData.CompanyId)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData); }
public DataBaseResultSet SaveT_MstRole <T>(T objData) where T : class, IModel, new() { T_MstRole obj = objData as T_MstRole; string sQuery = "sprocT_MstRoleInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RoleId", "RoleId", 4, GenericDataType.Int, ParameterDirection.Input, obj.RoleId)); list.Add(SqlConnManager.GetConnParameters("RoleName", "RoleName", 100, GenericDataType.String, ParameterDirection.Input, obj.RoleName)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public DataBaseResultSet SaveT_MstBroker <T>(T objData) where T : class, IModel, new() { T_MstBroker obj = objData as T_MstBroker; string sQuery = "sprocT_MstBrokerInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("BrokerCode", "BrokerCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.BrokerCode)); list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId)); list.Add(SqlConnManager.GetConnParameters("BrokerName", "BrokerName", 100, GenericDataType.String, ParameterDirection.Input, obj.BrokerName)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }