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);
}
