/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CustomerService.Model.Service model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@GUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@sNO", SqlDbType.VarChar, 50),
new SqlParameter("@customer", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@acceptDate", SqlDbType.DateTime),
new SqlParameter("@solutionDate", SqlDbType.DateTime),
new SqlParameter("@type", SqlDbType.VarChar, 20),
new SqlParameter("@content", SqlDbType.VarChar, 500),
new SqlParameter("@result", SqlDbType.VarChar, 100),
new SqlParameter("@evaluate", SqlDbType.VarChar, 50),
new SqlParameter("@material", SqlDbType.VarChar, 50),
new SqlParameter("@materialMoney", SqlDbType.Money, 8),
new SqlParameter("@serviceMoney", SqlDbType.Money, 8),
new SqlParameter("@payStatus", SqlDbType.VarChar, 50),
new SqlParameter("@traffic", SqlDbType.VarChar, 50),
new SqlParameter("@employee", SqlDbType.VarChar, 20),
new SqlParameter("@createDate", SqlDbType.DateTime)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.sNO;
parameters[2].Value = model.customer;
parameters[3].Value = model.acceptDate;
parameters[4].Value = model.solutionDate;
parameters[5].Value = model.type;
parameters[6].Value = model.content;
parameters[7].Value = model.result;
parameters[8].Value = model.evaluate;
parameters[9].Value = model.material;
parameters[10].Value = model.materialMoney;
parameters[11].Value = model.serviceMoney;
parameters[12].Value = model.payStatus;
parameters[13].Value = model.traffic;
parameters[14].Value = model.employee;
parameters[15].Value = DateTime.Now;
DbHelperSQL.RunProcedure("T_Service_ADD", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CustomerService.Model.Service GetModel(Guid GUID)
{
SqlParameter[] parameters = {
new SqlParameter("@GUID", SqlDbType.UniqueIdentifier,16)};
parameters[0].Value = GUID;
CustomerService.Model.Service model=new CustomerService.Model.Service();
DataSet ds= DbHelperSQL.RunProcedure("T_Service_GetModel",parameters,"ds");
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["GUID"]!=null && ds.Tables[0].Rows[0]["GUID"].ToString()!="")
{
model.GUID=new Guid(ds.Tables[0].Rows[0]["GUID"].ToString());
}
if(ds.Tables[0].Rows[0]["sNO"]!=null && ds.Tables[0].Rows[0]["sNO"].ToString()!="")
{
model.sNO=ds.Tables[0].Rows[0]["sNO"].ToString();
}
if(ds.Tables[0].Rows[0]["customer"]!=null && ds.Tables[0].Rows[0]["customer"].ToString()!="")
{
model.customer=new Guid(ds.Tables[0].Rows[0]["customer"].ToString());
}
if(ds.Tables[0].Rows[0]["acceptDate"]!=null && ds.Tables[0].Rows[0]["acceptDate"].ToString()!="")
{
model.acceptDate=DateTime.Parse(ds.Tables[0].Rows[0]["acceptDate"].ToString());
}
if(ds.Tables[0].Rows[0]["solutionDate"]!=null && ds.Tables[0].Rows[0]["solutionDate"].ToString()!="")
{
model.solutionDate=DateTime.Parse(ds.Tables[0].Rows[0]["solutionDate"].ToString());
}
if(ds.Tables[0].Rows[0]["type"]!=null && ds.Tables[0].Rows[0]["type"].ToString()!="")
{
model.type=ds.Tables[0].Rows[0]["type"].ToString();
}
if(ds.Tables[0].Rows[0]["content"]!=null && ds.Tables[0].Rows[0]["content"].ToString()!="")
{
model.content=ds.Tables[0].Rows[0]["content"].ToString();
}
if(ds.Tables[0].Rows[0]["result"]!=null && ds.Tables[0].Rows[0]["result"].ToString()!="")
{
model.result=ds.Tables[0].Rows[0]["result"].ToString();
}
if(ds.Tables[0].Rows[0]["evaluate"]!=null && ds.Tables[0].Rows[0]["evaluate"].ToString()!="")
{
model.evaluate=ds.Tables[0].Rows[0]["evaluate"].ToString();
}
if(ds.Tables[0].Rows[0]["material"]!=null && ds.Tables[0].Rows[0]["material"].ToString()!="")
{
model.material=ds.Tables[0].Rows[0]["material"].ToString();
}
if(ds.Tables[0].Rows[0]["materialMoney"]!=null && ds.Tables[0].Rows[0]["materialMoney"].ToString()!="")
{
model.materialMoney=decimal.Parse(ds.Tables[0].Rows[0]["materialMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["serviceMoney"]!=null && ds.Tables[0].Rows[0]["serviceMoney"].ToString()!="")
{
model.serviceMoney=decimal.Parse(ds.Tables[0].Rows[0]["serviceMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["payStatus"]!=null && ds.Tables[0].Rows[0]["payStatus"].ToString()!="")
{
model.payStatus=ds.Tables[0].Rows[0]["payStatus"].ToString();
}
if(ds.Tables[0].Rows[0]["traffic"]!=null && ds.Tables[0].Rows[0]["traffic"].ToString()!="")
{
model.traffic=ds.Tables[0].Rows[0]["traffic"].ToString();
}
if(ds.Tables[0].Rows[0]["employee"]!=null && ds.Tables[0].Rows[0]["employee"].ToString()!="")
{
model.employee=ds.Tables[0].Rows[0]["employee"].ToString();
}
if(ds.Tables[0].Rows[0]["createDate"]!=null && ds.Tables[0].Rows[0]["createDate"].ToString()!="")
{
model.createDate=DateTime.Parse(ds.Tables[0].Rows[0]["createDate"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CustomerService.Model.Service GetModel(Guid GUID)
{
SqlParameter[] parameters =
{
new SqlParameter("@GUID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = GUID;
CustomerService.Model.Service model = new CustomerService.Model.Service();
DataSet ds = DbHelperSQL.RunProcedure("T_Service_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["GUID"] != null && ds.Tables[0].Rows[0]["GUID"].ToString() != "")
{
model.GUID = new Guid(ds.Tables[0].Rows[0]["GUID"].ToString());
}
if (ds.Tables[0].Rows[0]["sNO"] != null && ds.Tables[0].Rows[0]["sNO"].ToString() != "")
{
model.sNO = ds.Tables[0].Rows[0]["sNO"].ToString();
}
if (ds.Tables[0].Rows[0]["customer"] != null && ds.Tables[0].Rows[0]["customer"].ToString() != "")
{
model.customer = new Guid(ds.Tables[0].Rows[0]["customer"].ToString());
}
if (ds.Tables[0].Rows[0]["acceptDate"] != null && ds.Tables[0].Rows[0]["acceptDate"].ToString() != "")
{
model.acceptDate = DateTime.Parse(ds.Tables[0].Rows[0]["acceptDate"].ToString());
}
if (ds.Tables[0].Rows[0]["solutionDate"] != null && ds.Tables[0].Rows[0]["solutionDate"].ToString() != "")
{
model.solutionDate = DateTime.Parse(ds.Tables[0].Rows[0]["solutionDate"].ToString());
}
if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "")
{
model.type = ds.Tables[0].Rows[0]["type"].ToString();
}
if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "")
{
model.content = ds.Tables[0].Rows[0]["content"].ToString();
}
if (ds.Tables[0].Rows[0]["result"] != null && ds.Tables[0].Rows[0]["result"].ToString() != "")
{
model.result = ds.Tables[0].Rows[0]["result"].ToString();
}
if (ds.Tables[0].Rows[0]["evaluate"] != null && ds.Tables[0].Rows[0]["evaluate"].ToString() != "")
{
model.evaluate = ds.Tables[0].Rows[0]["evaluate"].ToString();
}
if (ds.Tables[0].Rows[0]["material"] != null && ds.Tables[0].Rows[0]["material"].ToString() != "")
{
model.material = ds.Tables[0].Rows[0]["material"].ToString();
}
if (ds.Tables[0].Rows[0]["materialMoney"] != null && ds.Tables[0].Rows[0]["materialMoney"].ToString() != "")
{
model.materialMoney = decimal.Parse(ds.Tables[0].Rows[0]["materialMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["serviceMoney"] != null && ds.Tables[0].Rows[0]["serviceMoney"].ToString() != "")
{
model.serviceMoney = decimal.Parse(ds.Tables[0].Rows[0]["serviceMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["payStatus"] != null && ds.Tables[0].Rows[0]["payStatus"].ToString() != "")
{
model.payStatus = ds.Tables[0].Rows[0]["payStatus"].ToString();
}
if (ds.Tables[0].Rows[0]["traffic"] != null && ds.Tables[0].Rows[0]["traffic"].ToString() != "")
{
model.traffic = ds.Tables[0].Rows[0]["traffic"].ToString();
}
if (ds.Tables[0].Rows[0]["employee"] != null && ds.Tables[0].Rows[0]["employee"].ToString() != "")
{
model.employee = ds.Tables[0].Rows[0]["employee"].ToString();
}
if (ds.Tables[0].Rows[0]["createDate"] != null && ds.Tables[0].Rows[0]["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(ds.Tables[0].Rows[0]["createDate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
