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