/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.StoreOutWaitingGoods DataRowToModel(DataRow row)
{
DTcms.Model.StoreOutWaitingGoods model = new DTcms.Model.StoreOutWaitingGoods();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["StoringOutTime"] != null && row["StoringOutTime"].ToString() != "")
{
model.StoringOutTime = DateTime.Parse(row["StoringOutTime"].ToString());
}
if (row["StoredOutTime"] != null && row["StoredOutTime"].ToString() != "")
{
model.StoredOutTime = DateTime.Parse(row["StoredOutTime"].ToString());
}
if (row["Admin"] != null)
{
model.Admin = row["Admin"].ToString();
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["StoreInGoodsId"] != null && row["StoreInGoodsId"].ToString() != "")
{
model.StoreInGoodsId = int.Parse(row["StoreInGoodsId"].ToString());
}
if (row["GoodsId"] != null && row["GoodsId"].ToString() != "")
{
model.GoodsId = int.Parse(row["GoodsId"].ToString());
}
if (row["StoreInOrderId"] != null && row["StoreInOrderId"].ToString() != "")
{
model.StoreInOrderId = int.Parse(row["StoreInOrderId"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.StoreOutWaitingGoods GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,CreateTime,StoringOutTime,StoredOutTime,Admin,Status,Remark,StoreInGoodsId,GoodsId,StoreInOrderId from StoreOutWaitingGoods ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
DTcms.Model.StoreOutWaitingGoods model = new DTcms.Model.StoreOutWaitingGoods();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.StoreOutWaitingGoods DataRowToModel(DataRow row)
{
DTcms.Model.StoreOutWaitingGoods model = new DTcms.Model.StoreOutWaitingGoods();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["StoringOutTime"] != null && row["StoringOutTime"].ToString() != "")
{
model.StoringOutTime = DateTime.Parse(row["StoringOutTime"].ToString());
}
if (row["StoredOutTime"] != null && row["StoredOutTime"].ToString() != "")
{
model.StoredOutTime = DateTime.Parse(row["StoredOutTime"].ToString());
}
if (row["Admin"] != null)
{
model.Admin = row["Admin"].ToString();
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["StoreInGoodsId"] != null && row["StoreInGoodsId"].ToString() != "")
{
model.StoreInGoodsId = int.Parse(row["StoreInGoodsId"].ToString());
}
if (row["GoodsId"] != null && row["GoodsId"].ToString() != "")
{
model.GoodsId = int.Parse(row["GoodsId"].ToString());
}
if (row["StoreInOrderId"] != null && row["StoreInOrderId"].ToString() != "")
{
model.StoreInOrderId = int.Parse(row["StoreInOrderId"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.StoreOutWaitingGoods GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,CreateTime,StoringOutTime,StoredOutTime,Admin,Status,Remark,StoreInGoodsId,GoodsId,StoreInOrderId from StoreOutWaitingGoods ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4) };
parameters[0].Value = Id;
DTcms.Model.StoreOutWaitingGoods model = new DTcms.Model.StoreOutWaitingGoods();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
public bool Add(DTcms.Model.StoreOutWaitingGoods model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into StoreOutWaitingGoods(");
strSql.Append("CreateTime,StoringOutTime,StoredOutTime,Admin,Status,Remark,StoreInGoodsId,GoodsId,StoreInOrderId)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@StoringOutTime,@StoredOutTime,@Admin,@Status,@Remark,@StoreInGoodsId,@GoodsId,@StoreInOrderId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@StoringOutTime", SqlDbType.DateTime),
new SqlParameter("@StoredOutTime", SqlDbType.DateTime),
new SqlParameter("@Admin", SqlDbType.NVarChar, 254),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 254),
new SqlParameter("@StoreInGoodsId", SqlDbType.Int, 4),
new SqlParameter("@GoodsId", SqlDbType.Int, 4),
new SqlParameter("@StoreInOrderId", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = model.StoringOutTime;
parameters[2].Value = model.StoredOutTime;
parameters[3].Value = model.Admin;
parameters[4].Value = model.Status;
parameters[5].Value = model.Remark;
parameters[6].Value = model.StoreInGoodsId;
parameters[7].Value = model.GoodsId;
parameters[8].Value = model.StoreInOrderId;
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务
model.Id = Convert.ToInt32(obj);
#region 车辆====================
if (model.GoodsVehicles.Count > 0)
{
StoreOutGoodsVehicle storeOutGoodsVehicleDAL = new StoreOutGoodsVehicle();
foreach (Model.StoreOutGoodsVehicle goodsVehicle in model.GoodsVehicles)
{
goodsVehicle.StoreOutWaitingGoodsId = model.Id;
storeOutGoodsVehicleDAL.Add(conn, trans, goodsVehicle);
}
}
#endregion
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(model.Id > 0);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DTcms.Model.StoreOutWaitingGoods model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update StoreOutWaitingGoods set ");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("StoringOutTime=@StoringOutTime,");
strSql.Append("StoredOutTime=@StoredOutTime,");
strSql.Append("Admin=@Admin,");
strSql.Append("Status=@Status,");
strSql.Append("Remark=@Remark,");
strSql.Append("StoreInGoodsId=@StoreInGoodsId,");
strSql.Append("GoodsId=@GoodsId,");
strSql.Append("StoreInOrderId=@StoreInOrderId");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@StoringOutTime", SqlDbType.DateTime),
new SqlParameter("@StoredOutTime", SqlDbType.DateTime),
new SqlParameter("@Admin", SqlDbType.NVarChar, 254),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 254),
new SqlParameter("@StoreInGoodsId", SqlDbType.Int, 4),
new SqlParameter("@GoodsId", SqlDbType.Int, 4),
new SqlParameter("@StoreInOrderId", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = model.StoringOutTime;
parameters[2].Value = model.StoredOutTime;
parameters[3].Value = model.Admin;
parameters[4].Value = model.Status;
parameters[5].Value = model.Remark;
parameters[6].Value = model.StoreInGoodsId;
parameters[7].Value = model.GoodsId;
parameters[8].Value = model.StoreInOrderId;
parameters[9].Value = model.Id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
#region 车辆====================
StoreOutGoodsVehicle storeOutGoodsVehicleDAL = new StoreOutGoodsVehicle();
storeOutGoodsVehicleDAL.Delete(conn, trans, model.Id);
if (model.GoodsVehicles.Count > 0)
{
foreach (Model.StoreOutGoodsVehicle goodsVehicle in model.GoodsVehicles)
{
goodsVehicle.StoreOutWaitingGoodsId = model.Id;
storeOutGoodsVehicleDAL.Add(conn, trans, goodsVehicle);
}
}
#endregion
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
