private void map(SOServiceInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]); oParam.ServiceAddress = Util.TrimNull(tempdr["ServiceAddress"]); oParam.ServiceReceiveName = Util.TrimNull(tempdr["ServiceReceiveName"]); oParam.ServicePhone = Util.TrimNull(tempdr["ServicePhone"]); oParam.ServiceExpectTime = Util.TrimNull(tempdr["ServiceExpectTime"]); oParam.ServiceMemo = Util.TrimNull(tempdr["ServiceMemo"]); oParam.ServiceAgreedTime = Util.TrimNull(tempdr["ServiceAgreedTime"]); oParam.ServiceActualTime = Util.TrimNull(tempdr["ServiceActualTime"]); oParam.ServiceQuality1 = Util.TrimIntNull(tempdr["ServiceQuality1"]); oParam.ServiceQuality2 = Util.TrimIntNull(tempdr["ServiceQuality2"]); oParam.ServiceQuality3 = Util.TrimIntNull(tempdr["ServiceQuality3"]); oParam.ServiceEvaluation1 = Util.TrimNull(tempdr["ServiceEvaluation1"]); oParam.ServiceEvaluation2 = Util.TrimNull(tempdr["ServiceEvaluation2"]); oParam.ServiceEvaluation3 = Util.TrimNull(tempdr["ServiceEvaluation3"]); }
public int UpdateSOService(SOServiceInfo oParam) { return new SOServiceDac().Update(oParam); }
public SOServiceInfo LoadSOService(int SOSysNo) { string sql = "select * from so_service where sosysno =" + SOSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); SOServiceInfo oInfo = new SOServiceInfo(); if (Util.HasMoreRow(ds)) map(oInfo, ds.Tables[0].Rows[0]); else oInfo = null; return oInfo; }
public int InsertSOService(SOServiceInfo oParam) { return new SOServiceDac().Insert(oParam); }
public int Insert(SOServiceInfo oParam) { string sql = @"INSERT INTO SO_Service ( SOSysNo, ServiceAddress, ServiceReceiveName, ServicePhone, ServiceExpectTime, ServiceMemo, ServiceAgreedTime, ServiceActualTime, ServiceQuality1, ServiceQuality2, ServiceQuality3, ServiceEvaluation1, ServiceEvaluation2, ServiceEvaluation3 ) VALUES ( @SOSysNo, @ServiceAddress, @ServiceReceiveName, @ServicePhone, @ServiceExpectTime, @ServiceMemo, @ServiceAgreedTime, @ServiceActualTime, @ServiceQuality1, @ServiceQuality2, @ServiceQuality3, @ServiceEvaluation1, @ServiceEvaluation2, @ServiceEvaluation3 );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4); SqlParameter paramServiceAddress = new SqlParameter("@ServiceAddress", SqlDbType.NVarChar, 200); SqlParameter paramServiceReceiveName = new SqlParameter("@ServiceReceiveName", SqlDbType.NVarChar, 50); SqlParameter paramServicePhone = new SqlParameter("@ServicePhone", SqlDbType.NVarChar, 100); SqlParameter paramServiceExpectTime = new SqlParameter("@ServiceExpectTime", SqlDbType.NVarChar, 100); SqlParameter paramServiceMemo = new SqlParameter("@ServiceMemo", SqlDbType.NVarChar, 500); SqlParameter paramServiceAgreedTime = new SqlParameter("@ServiceAgreedTime", SqlDbType.NVarChar, 100); SqlParameter paramServiceActualTime = new SqlParameter("@ServiceActualTime", SqlDbType.NVarChar, 100); SqlParameter paramServiceQuality1 = new SqlParameter("@ServiceQuality1", SqlDbType.Int, 4); SqlParameter paramServiceQuality2 = new SqlParameter("@ServiceQuality2", SqlDbType.Int, 4); SqlParameter paramServiceQuality3 = new SqlParameter("@ServiceQuality3", SqlDbType.Int, 4); SqlParameter paramServiceEvaluation1 = new SqlParameter("@ServiceEvaluation1", SqlDbType.NVarChar, 500); SqlParameter paramServiceEvaluation2 = new SqlParameter("@ServiceEvaluation2", SqlDbType.NVarChar, 500); SqlParameter paramServiceEvaluation3 = new SqlParameter("@ServiceEvaluation3", SqlDbType.NVarChar, 500); paramSysNo.Direction = ParameterDirection.Output; if (oParam.SOSysNo != AppConst.IntNull) paramSOSysNo.Value = oParam.SOSysNo; else paramSOSysNo.Value = System.DBNull.Value; if (oParam.ServiceAddress != AppConst.StringNull) paramServiceAddress.Value = oParam.ServiceAddress; else paramServiceAddress.Value = System.DBNull.Value; if (oParam.ServiceReceiveName != AppConst.StringNull) paramServiceReceiveName.Value = oParam.ServiceReceiveName; else paramServiceReceiveName.Value = System.DBNull.Value; if (oParam.ServicePhone != AppConst.StringNull) paramServicePhone.Value = oParam.ServicePhone; else paramServicePhone.Value = System.DBNull.Value; if (oParam.ServiceExpectTime != AppConst.StringNull) paramServiceExpectTime.Value = oParam.ServiceExpectTime; else paramServiceExpectTime.Value = System.DBNull.Value; if (oParam.ServiceMemo != AppConst.StringNull) paramServiceMemo.Value = oParam.ServiceMemo; else paramServiceMemo.Value = System.DBNull.Value; if (oParam.ServiceAgreedTime != AppConst.StringNull) paramServiceAgreedTime.Value = oParam.ServiceAgreedTime; else paramServiceAgreedTime.Value = System.DBNull.Value; if (oParam.ServiceActualTime != AppConst.StringNull) paramServiceActualTime.Value = oParam.ServiceActualTime; else paramServiceActualTime.Value = System.DBNull.Value; if (oParam.ServiceQuality1 != AppConst.IntNull) paramServiceQuality1.Value = oParam.ServiceQuality1; else paramServiceQuality1.Value = System.DBNull.Value; if (oParam.ServiceQuality2 != AppConst.IntNull) paramServiceQuality2.Value = oParam.ServiceQuality2; else paramServiceQuality2.Value = System.DBNull.Value; if (oParam.ServiceQuality3 != AppConst.IntNull) paramServiceQuality3.Value = oParam.ServiceQuality3; else paramServiceQuality3.Value = System.DBNull.Value; if (oParam.ServiceEvaluation1 != AppConst.StringNull) paramServiceEvaluation1.Value = oParam.ServiceEvaluation1; else paramServiceEvaluation1.Value = System.DBNull.Value; if (oParam.ServiceEvaluation2 != AppConst.StringNull) paramServiceEvaluation2.Value = oParam.ServiceEvaluation2; else paramServiceEvaluation2.Value = System.DBNull.Value; if (oParam.ServiceEvaluation3 != AppConst.StringNull) paramServiceEvaluation3.Value = oParam.ServiceEvaluation3; else paramServiceEvaluation3.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSOSysNo); cmd.Parameters.Add(paramServiceAddress); cmd.Parameters.Add(paramServiceReceiveName); cmd.Parameters.Add(paramServicePhone); cmd.Parameters.Add(paramServiceExpectTime); cmd.Parameters.Add(paramServiceMemo); cmd.Parameters.Add(paramServiceAgreedTime); cmd.Parameters.Add(paramServiceActualTime); cmd.Parameters.Add(paramServiceQuality1); cmd.Parameters.Add(paramServiceQuality2); cmd.Parameters.Add(paramServiceQuality3); cmd.Parameters.Add(paramServiceEvaluation1); cmd.Parameters.Add(paramServiceEvaluation2); cmd.Parameters.Add(paramServiceEvaluation3); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public int Update(SOServiceInfo oParam) { string sql = @"UPDATE SO_Service SET SOSysNo=@SOSysNo, ServiceAddress=@ServiceAddress, ServiceReceiveName=@ServiceReceiveName, ServicePhone=@ServicePhone, ServiceExpectTime=@ServiceExpectTime, ServiceMemo=@ServiceMemo, ServiceAgreedTime=@ServiceAgreedTime, ServiceActualTime=@ServiceActualTime, ServiceQuality1=@ServiceQuality1, ServiceQuality2=@ServiceQuality2, ServiceQuality3=@ServiceQuality3, ServiceEvaluation1=@ServiceEvaluation1, ServiceEvaluation2=@ServiceEvaluation2, ServiceEvaluation3=@ServiceEvaluation3 WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4); SqlParameter paramServiceAddress = new SqlParameter("@ServiceAddress", SqlDbType.NVarChar, 200); SqlParameter paramServiceReceiveName = new SqlParameter("@ServiceReceiveName", SqlDbType.NVarChar, 50); SqlParameter paramServicePhone = new SqlParameter("@ServicePhone", SqlDbType.NVarChar, 100); SqlParameter paramServiceExpectTime = new SqlParameter("@ServiceExpectTime", SqlDbType.NVarChar, 100); SqlParameter paramServiceMemo = new SqlParameter("@ServiceMemo", SqlDbType.NVarChar, 500); SqlParameter paramServiceAgreedTime = new SqlParameter("@ServiceAgreedTime", SqlDbType.NVarChar, 100); SqlParameter paramServiceActualTime = new SqlParameter("@ServiceActualTime", SqlDbType.NVarChar, 100); SqlParameter paramServiceQuality1 = new SqlParameter("@ServiceQuality1", SqlDbType.Int, 4); SqlParameter paramServiceQuality2 = new SqlParameter("@ServiceQuality2", SqlDbType.Int, 4); SqlParameter paramServiceQuality3 = new SqlParameter("@ServiceQuality3", SqlDbType.Int, 4); SqlParameter paramServiceEvaluation1 = new SqlParameter("@ServiceEvaluation1", SqlDbType.NVarChar, 500); SqlParameter paramServiceEvaluation2 = new SqlParameter("@ServiceEvaluation2", SqlDbType.NVarChar, 500); SqlParameter paramServiceEvaluation3 = new SqlParameter("@ServiceEvaluation3", SqlDbType.NVarChar, 500); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.SOSysNo != AppConst.IntNull) paramSOSysNo.Value = oParam.SOSysNo; else paramSOSysNo.Value = System.DBNull.Value; if (oParam.ServiceAddress != AppConst.StringNull) paramServiceAddress.Value = oParam.ServiceAddress; else paramServiceAddress.Value = System.DBNull.Value; if (oParam.ServiceReceiveName != AppConst.StringNull) paramServiceReceiveName.Value = oParam.ServiceReceiveName; else paramServiceReceiveName.Value = System.DBNull.Value; if (oParam.ServicePhone != AppConst.StringNull) paramServicePhone.Value = oParam.ServicePhone; else paramServicePhone.Value = System.DBNull.Value; if (oParam.ServiceExpectTime != AppConst.StringNull) paramServiceExpectTime.Value = oParam.ServiceExpectTime; else paramServiceExpectTime.Value = System.DBNull.Value; if (oParam.ServiceMemo != AppConst.StringNull) paramServiceMemo.Value = oParam.ServiceMemo; else paramServiceMemo.Value = System.DBNull.Value; if (oParam.ServiceAgreedTime != AppConst.StringNull) paramServiceAgreedTime.Value = oParam.ServiceAgreedTime; else paramServiceAgreedTime.Value = System.DBNull.Value; if (oParam.ServiceActualTime != AppConst.StringNull) paramServiceActualTime.Value = oParam.ServiceActualTime; else paramServiceActualTime.Value = System.DBNull.Value; if (oParam.ServiceQuality1 != AppConst.IntNull) paramServiceQuality1.Value = oParam.ServiceQuality1; else paramServiceQuality1.Value = System.DBNull.Value; if (oParam.ServiceQuality2 != AppConst.IntNull) paramServiceQuality2.Value = oParam.ServiceQuality2; else paramServiceQuality2.Value = System.DBNull.Value; if (oParam.ServiceQuality3 != AppConst.IntNull) paramServiceQuality3.Value = oParam.ServiceQuality3; else paramServiceQuality3.Value = System.DBNull.Value; if (oParam.ServiceEvaluation1 != AppConst.StringNull) paramServiceEvaluation1.Value = oParam.ServiceEvaluation1; else paramServiceEvaluation1.Value = System.DBNull.Value; if (oParam.ServiceEvaluation2 != AppConst.StringNull) paramServiceEvaluation2.Value = oParam.ServiceEvaluation2; else paramServiceEvaluation2.Value = System.DBNull.Value; if (oParam.ServiceEvaluation3 != AppConst.StringNull) paramServiceEvaluation3.Value = oParam.ServiceEvaluation3; else paramServiceEvaluation3.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSOSysNo); cmd.Parameters.Add(paramServiceAddress); cmd.Parameters.Add(paramServiceReceiveName); cmd.Parameters.Add(paramServicePhone); cmd.Parameters.Add(paramServiceExpectTime); cmd.Parameters.Add(paramServiceMemo); cmd.Parameters.Add(paramServiceAgreedTime); cmd.Parameters.Add(paramServiceActualTime); cmd.Parameters.Add(paramServiceQuality1); cmd.Parameters.Add(paramServiceQuality2); cmd.Parameters.Add(paramServiceQuality3); cmd.Parameters.Add(paramServiceEvaluation1); cmd.Parameters.Add(paramServiceEvaluation2); cmd.Parameters.Add(paramServiceEvaluation3); return SqlHelper.ExecuteNonQuery(cmd); }