public long lngUpdateALLFiledsByPrimaryKey(IPrincipal p_objPrincipal, clsBill_VO p_objEntity, int p_Id) { long lngRes = -1; clsHRPTableService HRPSvc = new clsHRPTableService(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsBillSvc", "lngUpdateALLFiledsByPrimaryKey"); if (lngRes < 0) { return(-1); } string strSQL = "UPDATE t_bse_bill " + " SET " + "billid_int=?,billtype_chr=?,billno_vchr=?,status_int=?,inempid_chr=?,indatetime_dat=?,inoprid_chr=?,inoprdatetime_dat=?,outempid_chr=?,outdatetime_dat=?,outoprid_chr=?,outoprdatetime_dat=?,returnempid_chr=?,returndatetime_dat=?,returnoprid_chr=?,returnoprdatetime_dat=?,useempid_chr=?,usedatetime_dat=?,cancelempid_chr=?,canceldatetime_dat=?,refempid_chr=?,refdatetime_dat=?,note_vchr=?,totalsum_mny=?,acctsum_mny=?,sbsum_mny=?" + " WHERE billid_int= '" + p_Id.ToString() + "'"; try { IDataParameter[] paramArr = null; HRPSvc.CreateDatabaseParameter(26, out paramArr); paramArr[0].Value = p_objEntity.Billid_int; paramArr[1].Value = p_objEntity.Billtype_chr; paramArr[2].Value = p_objEntity.Billno_vchr; paramArr[3].Value = p_objEntity.Status_int; paramArr[4].Value = p_objEntity.Inempid_chr; paramArr[5].Value = p_objEntity.Indatetime_dat; paramArr[6].Value = p_objEntity.Inoprid_chr; paramArr[7].Value = p_objEntity.Inoprdatetime_dat; paramArr[8].Value = p_objEntity.Outempid_chr; paramArr[9].Value = p_objEntity.Outdatetime_dat; paramArr[10].Value = p_objEntity.Outoprid_chr; paramArr[11].Value = p_objEntity.Outoprdatetime_dat; paramArr[12].Value = p_objEntity.Returnempid_chr; paramArr[13].Value = p_objEntity.Returndatetime_dat; paramArr[14].Value = p_objEntity.Returnoprid_chr; paramArr[15].Value = p_objEntity.Returnoprdatetime_dat; paramArr[16].Value = p_objEntity.Useempid_chr; paramArr[17].Value = p_objEntity.Usedatetime_dat; paramArr[18].Value = p_objEntity.Cancelempid_chr; paramArr[19].Value = p_objEntity.Canceldatetime_dat; paramArr[20].Value = p_objEntity.Refempid_chr; paramArr[21].Value = p_objEntity.Refdatetime_dat; paramArr[22].Value = p_objEntity.Note_vchr; paramArr[23].Value = p_objEntity.Totalsum_mny; paramArr[24].Value = p_objEntity.Acctsum_mny; paramArr[25].Value = p_objEntity.Sbsum_mny; long lngRecordsAffected = -1; lngRes = HRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr); HRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long lngInsert(IPrincipal p_objPrincipal, clsBill_VO p_objEntity, out int p_intBillid_int) { long lngRes = -1; p_intBillid_int = -1; clsHRPTableService HRPSvc = new clsHRPTableService(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsBillSvc", "lngInsert"); if (lngRes < 0) { return(-1); } string strSQL = string.Format( "INSERT INTO t_bse_bill( " + "billid_int,billtype_chr,billno_vchr,status_int,inempid_chr,indatetime_dat,inoprid_chr,inoprdatetime_dat,outempid_chr,outdatetime_dat,outoprid_chr,outoprdatetime_dat,returnempid_chr,returndatetime_dat,returnoprid_chr,returnoprdatetime_dat,useempid_chr,usedatetime_dat,cancelempid_chr,canceldatetime_dat,refempid_chr,refdatetime_dat,note_vchr,totalsum_mny,acctsum_mny,sbsum_mny" + ") VALUES ( " + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?" + ")"); try { int strRecordID = -1; lngRes = HRPSvc.m_lngGenerateNewID("t_bse_bill", "billid_int", out strRecordID); if (lngRes > 0) { IDataParameter[] paramArr = null; HRPSvc.CreateDatabaseParameter(26, out paramArr); paramArr[0].Value = strRecordID; paramArr[1].Value = p_objEntity.Billtype_chr; paramArr[2].Value = p_objEntity.Billno_vchr; paramArr[3].Value = p_objEntity.Status_int; paramArr[4].Value = p_objEntity.Inempid_chr; paramArr[5].Value = p_objEntity.Indatetime_dat; paramArr[6].Value = p_objEntity.Inoprid_chr; paramArr[7].Value = p_objEntity.Inoprdatetime_dat; paramArr[8].Value = p_objEntity.Outempid_chr; paramArr[9].Value = p_objEntity.Outdatetime_dat; paramArr[10].Value = p_objEntity.Outoprid_chr; paramArr[11].Value = p_objEntity.Outoprdatetime_dat; paramArr[12].Value = p_objEntity.Returnempid_chr; paramArr[13].Value = p_objEntity.Returndatetime_dat; paramArr[14].Value = p_objEntity.Returnoprid_chr; paramArr[15].Value = p_objEntity.Returnoprdatetime_dat; paramArr[16].Value = p_objEntity.Useempid_chr; paramArr[17].Value = p_objEntity.Usedatetime_dat; paramArr[18].Value = p_objEntity.Cancelempid_chr; paramArr[19].Value = p_objEntity.Canceldatetime_dat; paramArr[20].Value = p_objEntity.Refempid_chr; paramArr[21].Value = p_objEntity.Refdatetime_dat; paramArr[22].Value = p_objEntity.Note_vchr; paramArr[23].Value = p_objEntity.Totalsum_mny; paramArr[24].Value = p_objEntity.Acctsum_mny; paramArr[25].Value = p_objEntity.Sbsum_mny; long lngRecordsAffected = -1; lngRes = HRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr); HRPSvc.Dispose(); } } catch (Exception objEx) { string strTmp = objEx.Message; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long lngSelectByCondition(IPrincipal p_objPrincipal, string p_strWhereCondition, out clsBill_VO[] p_objEntity) { long lngRes = -1; p_objEntity = null; clsHRPTableService HRPSvc = new clsHRPTableService(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsBillSvc", "lngSelectRecordCount"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT billid_int, billtype_chr, billno_vchr, status_int, inempid_chr, indatetime_dat, inoprid_chr, inoprdatetime_dat, outempid_chr, outdatetime_dat, outoprid_chr, outoprdatetime_dat, returnempid_chr, returndatetime_dat, returnoprid_chr, returnoprdatetime_dat, useempid_chr, usedatetime_dat, cancelempid_chr, canceldatetime_dat, refempid_chr, refdatetime_dat, note_vchr, totalsum_mny, acctsum_mny, sbsum_mny FROM t_bse_bill " ; if (p_strWhereCondition != "") { strSQL += " Where " + p_strWhereCondition; } try { DataTable p_objResultTable = null; lngRes = HRPSvc.DoGetDataTable(strSQL, ref p_objResultTable); if (lngRes > 0) { if (p_objResultTable.Rows.Count != 0) { p_objEntity = new clsBill_VO[p_objResultTable.Rows.Count]; for (int j = 0; j < p_objResultTable.Rows.Count; j++) { p_objEntity[j] = new clsBill_VO(); if (p_objResultTable.Rows[0]["billid_int"] != DBNull.Value) { p_objEntity[j].Billid_int = Convert.ToInt32(p_objResultTable.Rows[0]["billid_int"]); } if (p_objResultTable.Rows[0]["billtype_chr"] != DBNull.Value) { p_objEntity[j].Billtype_chr = Convert.ToString(p_objResultTable.Rows[0]["billtype_chr"]); } if (p_objResultTable.Rows[0]["billno_vchr"] != DBNull.Value) { p_objEntity[j].Billno_vchr = Convert.ToString(p_objResultTable.Rows[0]["billno_vchr"]); } if (p_objResultTable.Rows[0]["status_int"] != DBNull.Value) { p_objEntity[j].Status_int = Convert.ToInt32(p_objResultTable.Rows[0]["status_int"]); } if (p_objResultTable.Rows[0]["inempid_chr"] != DBNull.Value) { p_objEntity[j].Inempid_chr = Convert.ToString(p_objResultTable.Rows[0]["inempid_chr"]); } if (p_objResultTable.Rows[0]["indatetime_dat"] != DBNull.Value) { p_objEntity[j].Indatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["indatetime_dat"]); } if (p_objResultTable.Rows[0]["inoprid_chr"] != DBNull.Value) { p_objEntity[j].Inoprid_chr = Convert.ToString(p_objResultTable.Rows[0]["inoprid_chr"]); } if (p_objResultTable.Rows[0]["inoprdatetime_dat"] != DBNull.Value) { p_objEntity[j].Inoprdatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["inoprdatetime_dat"]); } if (p_objResultTable.Rows[0]["outempid_chr"] != DBNull.Value) { p_objEntity[j].Outempid_chr = Convert.ToString(p_objResultTable.Rows[0]["outempid_chr"]); } if (p_objResultTable.Rows[0]["outdatetime_dat"] != DBNull.Value) { p_objEntity[j].Outdatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["outdatetime_dat"]); } if (p_objResultTable.Rows[0]["outoprid_chr"] != DBNull.Value) { p_objEntity[j].Outoprid_chr = Convert.ToString(p_objResultTable.Rows[0]["outoprid_chr"]); } if (p_objResultTable.Rows[0]["outoprdatetime_dat"] != DBNull.Value) { p_objEntity[j].Outoprdatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["outoprdatetime_dat"]); } if (p_objResultTable.Rows[0]["returnempid_chr"] != DBNull.Value) { p_objEntity[j].Returnempid_chr = Convert.ToString(p_objResultTable.Rows[0]["returnempid_chr"]); } if (p_objResultTable.Rows[0]["returndatetime_dat"] != DBNull.Value) { p_objEntity[j].Returndatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["returndatetime_dat"]); } if (p_objResultTable.Rows[0]["returnoprid_chr"] != DBNull.Value) { p_objEntity[j].Returnoprid_chr = Convert.ToString(p_objResultTable.Rows[0]["returnoprid_chr"]); } if (p_objResultTable.Rows[0]["returnoprdatetime_dat"] != DBNull.Value) { p_objEntity[j].Returnoprdatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["returnoprdatetime_dat"]); } if (p_objResultTable.Rows[0]["useempid_chr"] != DBNull.Value) { p_objEntity[j].Useempid_chr = Convert.ToString(p_objResultTable.Rows[0]["useempid_chr"]); } if (p_objResultTable.Rows[0]["usedatetime_dat"] != DBNull.Value) { p_objEntity[j].Usedatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["usedatetime_dat"]); } if (p_objResultTable.Rows[0]["cancelempid_chr"] != DBNull.Value) { p_objEntity[j].Cancelempid_chr = Convert.ToString(p_objResultTable.Rows[0]["cancelempid_chr"]); } if (p_objResultTable.Rows[0]["canceldatetime_dat"] != DBNull.Value) { p_objEntity[j].Canceldatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["canceldatetime_dat"]); } if (p_objResultTable.Rows[0]["refempid_chr"] != DBNull.Value) { p_objEntity[j].Refempid_chr = Convert.ToString(p_objResultTable.Rows[0]["refempid_chr"]); } if (p_objResultTable.Rows[0]["refdatetime_dat"] != DBNull.Value) { p_objEntity[j].Refdatetime_dat = Convert.ToDateTime(p_objResultTable.Rows[0]["refdatetime_dat"]); } if (p_objResultTable.Rows[0]["note_vchr"] != DBNull.Value) { p_objEntity[j].Note_vchr = Convert.ToString(p_objResultTable.Rows[0]["note_vchr"]); } if (p_objResultTable.Rows[0]["totalsum_mny"] != DBNull.Value) { p_objEntity[j].Totalsum_mny = Convert.ToInt32(p_objResultTable.Rows[0]["totalsum_mny"]); } if (p_objResultTable.Rows[0]["acctsum_mny"] != DBNull.Value) { p_objEntity[j].Acctsum_mny = Convert.ToInt32(p_objResultTable.Rows[0]["acctsum_mny"]); } if (p_objResultTable.Rows[0]["sbsum_mny"] != DBNull.Value) { p_objEntity[j].Sbsum_mny = Convert.ToInt32(p_objResultTable.Rows[0]["sbsum_mny"]); } } } } HRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }