/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.order_info DataRowToModel(DataRow row)
{
MultiColorPen.Model.order_info model = new MultiColorPen.Model.order_info();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["number"] != null)
{
model.number = row["number"].ToString();
}
if (row["customer_name"] != null)
{
model.customer_name = row["customer_name"].ToString();
}
if (row["customer_address"] != null)
{
model.customer_address = row["customer_address"].ToString();
}
if (row["customer_tel"] != null)
{
model.customer_tel = row["customer_tel"].ToString();
}
if (row["customer_person"] != null)
{
model.customer_person = row["customer_person"].ToString();
}
if (row["customer_id"] != null && row["customer_id"].ToString() != "")
{
model.customer_id = int.Parse(row["customer_id"].ToString());
}
if (row["create_time"] != null)
{
model.create_time = row["create_time"].ToString();
}
if (row["delivery_time"] != null)
{
model.delivery_time = row["delivery_time"].ToString();
}
if (row["status"] != null)
{
model.status = row["status"].ToString();
}
if (row["is_del"] != null)
{
model.is_del = row["is_del"].ToString();
}
if (row["mark"] != null)
{
model.mark = row["mark"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.order_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update order_info set ");
strSql.Append("number=?number,");
strSql.Append("customer_name=?customer_name,");
strSql.Append("customer_address=?customer_address,");
strSql.Append("customer_tel=?customer_tel,");
strSql.Append("customer_person=?customer_person,");
strSql.Append("customer_id=?customer_id,");
strSql.Append("create_time=?create_time,");
strSql.Append("delivery_time=?delivery_time,");
strSql.Append("status=?status,");
strSql.Append("is_del=?is_del,");
strSql.Append("mark=?mark");
strSql.Append(" where id=?id");
MySqlParameter[] parameters =
{
new MySqlParameter("?number", MySqlDbType.VarChar, 30),
new MySqlParameter("?customer_name", MySqlDbType.VarChar, 50),
new MySqlParameter("?customer_address", MySqlDbType.VarChar, 100),
new MySqlParameter("?customer_tel", MySqlDbType.VarChar, 20),
new MySqlParameter("?customer_person", MySqlDbType.VarChar, 20),
new MySqlParameter("?customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("?create_time", MySqlDbType.VarChar, 11),
new MySqlParameter("?delivery_time", MySqlDbType.VarChar, 11),
new MySqlParameter("?status", MySqlDbType.VarChar, 10),
new MySqlParameter("?is_del", MySqlDbType.VarChar, 2),
new MySqlParameter("?mark", MySqlDbType.VarChar, 155),
new MySqlParameter("?id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.number;
parameters[1].Value = model.customer_name;
parameters[2].Value = model.customer_address;
parameters[3].Value = model.customer_tel;
parameters[4].Value = model.customer_person;
parameters[5].Value = model.customer_id;
parameters[6].Value = model.create_time;
parameters[7].Value = model.delivery_time;
parameters[8].Value = model.status;
parameters[9].Value = model.is_del;
parameters[10].Value = model.mark;
parameters[11].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MultiColorPen.Model.order_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into order_info(");
strSql.Append("number,customer_name,customer_address,customer_tel,customer_person,customer_id,create_time,delivery_time,status,is_del,mark)");
strSql.Append(" values (");
strSql.Append("?number,?customer_name,?customer_address,?customer_tel,?customer_person,?customer_id,?create_time,?delivery_time,?status,?is_del,?mark)");
MySqlParameter[] parameters =
{
new MySqlParameter("?number", MySqlDbType.VarChar, 30),
new MySqlParameter("?customer_name", MySqlDbType.VarChar, 50),
new MySqlParameter("?customer_address", MySqlDbType.VarChar, 100),
new MySqlParameter("?customer_tel", MySqlDbType.VarChar, 20),
new MySqlParameter("?customer_person", MySqlDbType.VarChar, 20),
new MySqlParameter("?customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("?create_time", MySqlDbType.VarChar, 11),
new MySqlParameter("?delivery_time", MySqlDbType.VarChar, 11),
new MySqlParameter("?status", MySqlDbType.VarChar, 10),
new MySqlParameter("?is_del", MySqlDbType.VarChar, 2),
new MySqlParameter("?mark", MySqlDbType.VarChar, 155)
};
parameters[0].Value = model.number;
parameters[1].Value = model.customer_name;
parameters[2].Value = model.customer_address;
parameters[3].Value = model.customer_tel;
parameters[4].Value = model.customer_person;
parameters[5].Value = model.customer_id;
parameters[6].Value = model.create_time;
parameters[7].Value = model.delivery_time;
parameters[8].Value = model.status;
parameters[9].Value = model.is_del;
parameters[10].Value = model.mark;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.order_info GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,number,customer_name,customer_address,customer_tel,customer_person,customer_id,create_time,delivery_time,status,is_del,mark from order_info ");
strSql.Append(" where id=?id");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32)
};
parameters[0].Value = id;
MultiColorPen.Model.order_info model = new MultiColorPen.Model.order_info();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public string SaveOrder(string json, string orderInfo)
{
//json = json.Replace("[","").Replace("]","");
orderInfo = orderInfo.Replace("[", "").Replace("]", "");
var bllOrder = new MultiColorPen.BLL.order_info();
var bllDetail = new MultiColorPen.BLL.order_detail();
var bllCommo = new MultiColorPen.BLL.commodity();
var bllCustomer = new MultiColorPen.BLL.customer();
bool isSuccess = true;
string orderNumber = "";//订单编号
JArray jArray = JArray.Parse(json);
var oldOrderInfo = new MultiColorPen.Model.order_info();
ResultInfo result = new ResultInfo(false);
JObject jo = JObject.Parse(orderInfo); //解析order信息
if (jo["orderId"].ToString() == "-1") //新增订单
{
orderNumber = "ORDER" + DateTime.Now.ToString("yyyyMMddHHmmss");
}
else
{
oldOrderInfo = bllOrder.GetModel((int)jo["orderId"]); //获取旧的订单信息
orderNumber = oldOrderInfo.number; //编辑时使用旧的订单编号
oldOrderInfo.is_del = "1";
if (!bllOrder.Update(oldOrderInfo)) //删除旧的订单信息
{
isSuccess = false;
}
if (!bllDetail.DeleteByWhere(" order_number='" + orderNumber + "'")) //删除详细商品的对应数据
{
isSuccess = false;
}
}
foreach (var jj in jArray)
{
JObject jdata = (JObject)jj;
var commodityModel = bllCommo.GetModel((int)jdata["name"]);
var orderDetailModel = new MultiColorPen.Model.order_detail();
orderDetailModel.commodity_count = (int)jdata["count"];
orderDetailModel.commodity_id = (int)jdata["name"];
orderDetailModel.commodity_price = commodityModel.price;
orderDetailModel.commodity_unit = commodityModel.unit;
orderDetailModel.order_number = orderNumber;
orderDetailModel.commodity_name = commodityModel.name;
orderDetailModel.mark = jdata["mark"].ToString();
orderDetailModel.is_del = "0";
if (!bllDetail.Add(orderDetailModel)) //插入商品详情
{
isSuccess = false;
}
}
var customerModel = bllCustomer.GetModel((int)jo["customerId"]);
var orderModel = new MultiColorPen.Model.order_info();
orderModel.create_time = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");
orderModel.customer_id = (int)jo["customerId"];
orderModel.customer_address = customerModel.address;
orderModel.customer_name = customerModel.name;
orderModel.customer_person = customerModel.person;
orderModel.customer_tel = customerModel.tel;
orderModel.delivery_time = jo["deliverTime"].ToString();
orderModel.is_del = "0";
orderModel.status = "已下单";
orderModel.number = orderNumber;
orderModel.mark = jo["orderMark"].ToString();
if (!bllOrder.Add(orderModel)) //插入订单信息
{
isSuccess = false;
}
if (isSuccess)
{
result.IsSucceed = true;
result.Message = "操作成功!";
}
else
{
result.IsSucceed = false;
result.Message = "修改失败！";
}
return(JsonConvert.SerializeObject(result));
}
