/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Sys.Model.Orders model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Orders(");
strSql.Append("UserLoginId,WorkerId,ProjectName,CustomName,ProvinceId,ProvinceName,CityId,CityName,AreaId,AreaName,sAreaId,sAreaName,Address,Contact,Tel,HandleDate,OrderStatus,StatusFlag,Remark,PicList,CreateUserId,CreateDate,ModifyUserId,ModifyDate)");
strSql.Append(" values (");
strSql.Append("@UserLoginId,@WorkerId,@ProjectName,@CustomName,@ProvinceId,@ProvinceName,@CityId,@CityName,@AreaId,@AreaName,@sAreaId,@sAreaName,@Address,@Contact,@Tel,@HandleDate,@OrderStatus,@StatusFlag,@Remark,@PicList,@CreateUserId,@CreateDate,@ModifyUserId,@ModifyDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserLoginId", SqlDbType.VarChar, 50),
new SqlParameter("@WorkerId", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectName", SqlDbType.NVarChar, 100),
new SqlParameter("@CustomName", SqlDbType.NVarChar, 100),
new SqlParameter("@ProvinceId", SqlDbType.Int, 4),
new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50),
new SqlParameter("@CityId", SqlDbType.Int, 4),
new SqlParameter("@CityName", SqlDbType.NVarChar, 50),
new SqlParameter("@AreaId", SqlDbType.Int, 4),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@sAreaId", SqlDbType.Int, 4),
new SqlParameter("@sAreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@Address", SqlDbType.NVarChar, 100),
new SqlParameter("@Contact", SqlDbType.NVarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@HandleDate", SqlDbType.DateTime),
new SqlParameter("@OrderStatus", SqlDbType.VarChar, 1),
new SqlParameter("@StatusFlag", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@PicList", SqlDbType.VarChar, 200),
new SqlParameter("@CreateUserId", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ModifyUserId", SqlDbType.VarChar, 50),
new SqlParameter("@ModifyDate", SqlDbType.DateTime)
};
parameters[0].Value = model.UserLoginId;
parameters[1].Value = model.WorkerId;
parameters[2].Value = model.ProjectName;
parameters[3].Value = model.CustomName;
parameters[4].Value = model.ProvinceId;
parameters[5].Value = model.ProvinceName;
parameters[6].Value = model.CityId;
parameters[7].Value = model.CityName;
parameters[8].Value = model.AreaId;
parameters[9].Value = model.AreaName;
parameters[10].Value = model.sAreaId;
parameters[11].Value = model.sAreaName;
parameters[12].Value = model.Address;
parameters[13].Value = model.Contact;
parameters[14].Value = model.Tel;
parameters[15].Value = model.HandleDate;
parameters[16].Value = model.OrderStatus;
parameters[17].Value = model.StatusFlag;
parameters[18].Value = model.Remark;
parameters[19].Value = model.PicList;
parameters[20].Value = model.CreateUserId;
parameters[21].Value = model.CreateDate;
parameters[22].Value = model.ModifyUserId;
parameters[23].Value = model.ModifyDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys.Model.Orders model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Orders set ");
strSql.Append("UserLoginId=@UserLoginId,");
strSql.Append("WorkerId=@WorkerId,");
strSql.Append("ProjectName=@ProjectName,");
strSql.Append("CustomName=@CustomName,");
strSql.Append("ProvinceId=@ProvinceId,");
strSql.Append("ProvinceName=@ProvinceName,");
strSql.Append("CityId=@CityId,");
strSql.Append("CityName=@CityName,");
strSql.Append("AreaId=@AreaId,");
strSql.Append("AreaName=@AreaName,");
strSql.Append("sAreaId=@sAreaId,");
strSql.Append("sAreaName=@sAreaName,");
strSql.Append("Address=@Address,");
strSql.Append("Contact=@Contact,");
strSql.Append("Tel=@Tel,");
strSql.Append("HandleDate=@HandleDate,");
strSql.Append("OrderStatus=@OrderStatus,");
strSql.Append("StatusFlag=@StatusFlag,");
strSql.Append("Remark=@Remark,");
strSql.Append("PicList=@PicList,");
strSql.Append("CreateUserId=@CreateUserId,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("ModifyUserId=@ModifyUserId,");
strSql.Append("ModifyDate=@ModifyDate");
strSql.Append(" where OrderId=@OrderId");
SqlParameter[] parameters =
{
new SqlParameter("@UserLoginId", SqlDbType.VarChar, 50),
new SqlParameter("@WorkerId", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectName", SqlDbType.NVarChar, 100),
new SqlParameter("@CustomName", SqlDbType.NVarChar, 100),
new SqlParameter("@ProvinceId", SqlDbType.Int, 4),
new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50),
new SqlParameter("@CityId", SqlDbType.Int, 4),
new SqlParameter("@CityName", SqlDbType.NVarChar, 50),
new SqlParameter("@AreaId", SqlDbType.Int, 4),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@sAreaId", SqlDbType.Int, 4),
new SqlParameter("@sAreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@Address", SqlDbType.NVarChar, 100),
new SqlParameter("@Contact", SqlDbType.NVarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@HandleDate", SqlDbType.DateTime),
new SqlParameter("@OrderStatus", SqlDbType.VarChar, 1),
new SqlParameter("@StatusFlag", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@PicList", SqlDbType.VarChar, 200),
new SqlParameter("@CreateUserId", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ModifyUserId", SqlDbType.VarChar, 50),
new SqlParameter("@ModifyDate", SqlDbType.DateTime),
new SqlParameter("@OrderId", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserLoginId;
parameters[1].Value = model.WorkerId;
parameters[2].Value = model.ProjectName;
parameters[3].Value = model.CustomName;
parameters[4].Value = model.ProvinceId;
parameters[5].Value = model.ProvinceName;
parameters[6].Value = model.CityId;
parameters[7].Value = model.CityName;
parameters[8].Value = model.AreaId;
parameters[9].Value = model.AreaName;
parameters[10].Value = model.sAreaId;
parameters[11].Value = model.sAreaName;
parameters[12].Value = model.Address;
parameters[13].Value = model.Contact;
parameters[14].Value = model.Tel;
parameters[15].Value = model.HandleDate;
parameters[16].Value = model.OrderStatus;
parameters[17].Value = model.StatusFlag;
parameters[18].Value = model.Remark;
parameters[19].Value = model.PicList;
parameters[20].Value = model.CreateUserId;
parameters[21].Value = model.CreateDate;
parameters[22].Value = model.ModifyUserId;
parameters[23].Value = model.ModifyDate;
parameters[24].Value = model.OrderId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Sys.Model.Orders GetModel(int OrderId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderId,UserLoginId,WorkerId,ProjectName,CustomName,ProvinceId,ProvinceName,CityId,CityName,AreaId,AreaName,sAreaId,sAreaName,Address,Contact,Tel,HandleDate,OrderStatus,StatusFlag,Remark,PicList,CreateUserId,CreateDate,ModifyUserId,ModifyDate from Orders ");
strSql.Append(" where OrderId=@OrderId");
SqlParameter[] parameters =
{
new SqlParameter("@OrderId", SqlDbType.Int, 4)
};
parameters[0].Value = OrderId;
Sys.Model.Orders model = new Sys.Model.Orders();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["OrderId"] != null && ds.Tables[0].Rows[0]["OrderId"].ToString() != "")
{
model.OrderId = int.Parse(ds.Tables[0].Rows[0]["OrderId"].ToString());
}
if (ds.Tables[0].Rows[0]["UserLoginId"] != null && ds.Tables[0].Rows[0]["UserLoginId"].ToString() != "")
{
model.UserLoginId = ds.Tables[0].Rows[0]["UserLoginId"].ToString();
}
if (ds.Tables[0].Rows[0]["WorkerId"] != null && ds.Tables[0].Rows[0]["WorkerId"].ToString() != "")
{
model.WorkerId = ds.Tables[0].Rows[0]["WorkerId"].ToString();
}
if (ds.Tables[0].Rows[0]["ProjectName"] != null && ds.Tables[0].Rows[0]["ProjectName"].ToString() != "")
{
model.ProjectName = ds.Tables[0].Rows[0]["ProjectName"].ToString();
}
if (ds.Tables[0].Rows[0]["CustomName"] != null && ds.Tables[0].Rows[0]["CustomName"].ToString() != "")
{
model.CustomName = ds.Tables[0].Rows[0]["CustomName"].ToString();
}
if (ds.Tables[0].Rows[0]["ProvinceId"] != null && ds.Tables[0].Rows[0]["ProvinceId"].ToString() != "")
{
model.ProvinceId = int.Parse(ds.Tables[0].Rows[0]["ProvinceId"].ToString());
}
if (ds.Tables[0].Rows[0]["ProvinceName"] != null && ds.Tables[0].Rows[0]["ProvinceName"].ToString() != "")
{
model.ProvinceName = ds.Tables[0].Rows[0]["ProvinceName"].ToString();
}
if (ds.Tables[0].Rows[0]["CityId"] != null && ds.Tables[0].Rows[0]["CityId"].ToString() != "")
{
model.CityId = int.Parse(ds.Tables[0].Rows[0]["CityId"].ToString());
}
if (ds.Tables[0].Rows[0]["CityName"] != null && ds.Tables[0].Rows[0]["CityName"].ToString() != "")
{
model.CityName = ds.Tables[0].Rows[0]["CityName"].ToString();
}
if (ds.Tables[0].Rows[0]["AreaId"] != null && ds.Tables[0].Rows[0]["AreaId"].ToString() != "")
{
model.AreaId = int.Parse(ds.Tables[0].Rows[0]["AreaId"].ToString());
}
if (ds.Tables[0].Rows[0]["AreaName"] != null && ds.Tables[0].Rows[0]["AreaName"].ToString() != "")
{
model.AreaName = ds.Tables[0].Rows[0]["AreaName"].ToString();
}
if (ds.Tables[0].Rows[0]["sAreaId"] != null && ds.Tables[0].Rows[0]["sAreaId"].ToString() != "")
{
model.sAreaId = int.Parse(ds.Tables[0].Rows[0]["sAreaId"].ToString());
}
if (ds.Tables[0].Rows[0]["sAreaName"] != null && ds.Tables[0].Rows[0]["sAreaName"].ToString() != "")
{
model.sAreaName = ds.Tables[0].Rows[0]["sAreaName"].ToString();
}
if (ds.Tables[0].Rows[0]["Address"] != null && ds.Tables[0].Rows[0]["Address"].ToString() != "")
{
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
}
if (ds.Tables[0].Rows[0]["Contact"] != null && ds.Tables[0].Rows[0]["Contact"].ToString() != "")
{
model.Contact = ds.Tables[0].Rows[0]["Contact"].ToString();
}
if (ds.Tables[0].Rows[0]["Tel"] != null && ds.Tables[0].Rows[0]["Tel"].ToString() != "")
{
model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString();
}
if (ds.Tables[0].Rows[0]["HandleDate"] != null && ds.Tables[0].Rows[0]["HandleDate"].ToString() != "")
{
model.HandleDate = DateTime.Parse(ds.Tables[0].Rows[0]["HandleDate"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderStatus"] != null && ds.Tables[0].Rows[0]["OrderStatus"].ToString() != "")
{
model.OrderStatus = ds.Tables[0].Rows[0]["OrderStatus"].ToString();
}
if (ds.Tables[0].Rows[0]["StatusFlag"] != null && ds.Tables[0].Rows[0]["StatusFlag"].ToString() != "")
{
model.StatusFlag = int.Parse(ds.Tables[0].Rows[0]["StatusFlag"].ToString());
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
if (ds.Tables[0].Rows[0]["PicList"] != null && ds.Tables[0].Rows[0]["PicList"].ToString() != "")
{
model.PicList = ds.Tables[0].Rows[0]["PicList"].ToString();
}
if (ds.Tables[0].Rows[0]["CreateUserId"] != null && ds.Tables[0].Rows[0]["CreateUserId"].ToString() != "")
{
model.CreateUserId = ds.Tables[0].Rows[0]["CreateUserId"].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());
}
if (ds.Tables[0].Rows[0]["ModifyUserId"] != null && ds.Tables[0].Rows[0]["ModifyUserId"].ToString() != "")
{
model.ModifyUserId = ds.Tables[0].Rows[0]["ModifyUserId"].ToString();
}
if (ds.Tables[0].Rows[0]["ModifyDate"] != null && ds.Tables[0].Rows[0]["ModifyDate"].ToString() != "")
{
model.ModifyDate = DateTime.Parse(ds.Tables[0].Rows[0]["ModifyDate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Sys.Model.Orders model, int type)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@OrderId", SqlDbType.Int, 4),
new SqlParameter("@UserLoginId", SqlDbType.VarChar, 50),
new SqlParameter("@WorkerId", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectName", SqlDbType.NVarChar, 100),
new SqlParameter("@CustomName", SqlDbType.NVarChar, 100),
new SqlParameter("@ProvinceId", SqlDbType.Int, 4),
new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50),
new SqlParameter("@CityId", SqlDbType.Int, 4),
new SqlParameter("@CityName", SqlDbType.NVarChar, 50),
new SqlParameter("@AreaId", SqlDbType.Int, 4),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@sAreaId", SqlDbType.Int, 4),
new SqlParameter("@sAreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@Address", SqlDbType.NVarChar, 100),
new SqlParameter("@Contact", SqlDbType.NVarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@HandleDate", SqlDbType.DateTime),
new SqlParameter("@OrderStatus", SqlDbType.Char, 1),
new SqlParameter("@StatusFlag", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@PicList", SqlDbType.VarChar, 200),
new SqlParameter("@CreateUserId", SqlDbType.VarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ModifyUserId", SqlDbType.VarChar, 50),
new SqlParameter("@ModifyDate", SqlDbType.DateTime)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.UserLoginId;
parameters[2].Value = model.WorkerId;
parameters[3].Value = model.ProjectName;
parameters[4].Value = model.CustomName;
parameters[5].Value = model.ProvinceId;
parameters[6].Value = model.ProvinceName;
parameters[7].Value = model.CityId;
parameters[8].Value = model.CityName;
parameters[9].Value = model.AreaId;
parameters[10].Value = model.AreaName;
parameters[11].Value = model.sAreaId;
parameters[12].Value = model.sAreaName;
parameters[13].Value = model.Address;
parameters[14].Value = model.Contact;
parameters[15].Value = model.Tel;
parameters[16].Value = model.HandleDate;
parameters[17].Value = model.OrderStatus;
parameters[18].Value = model.StatusFlag;
parameters[19].Value = model.Remark;
parameters[20].Value = model.PicList;
parameters[21].Value = model.CreateUserId;
parameters[22].Value = model.CreateDate;
parameters[23].Value = model.ModifyUserId;
parameters[24].Value = model.ModifyDate;
DbHelperSQL.RunProcedure("Orders_ADD_New", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
