/// <summary>
/// 增加数据
/// </summary>
/// <param name="_model"></param>
/// <param name="_modelsList"></param>
/// <returns></returns>
public bool Add(FishEntity.BatchSheetEntity _model, List <FishEntity.BatchSheetsEntity> _modelsList, string name)
{
Hashtable SQLString = new Hashtable( );
SQLString = ReviewInfo.getSQLString(name, _model.code, string.Empty, SQLString);
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_batchsheet(");
strSql.Append("code,productionDate)");
strSql.Append(" values (");
strSql.Append("@code,@productionDate)");
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@productionDate", MySqlDbType.Date)
};
parameters [0].Value = _model.code;
parameters [1].Value = _model.productionDate;
SQLString.Add(strSql, parameters);
foreach (FishEntity.BatchSheetsEntity model in _modelsList)
{
add(SQLString, strSql, model);
}
return(MySqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_model"></param>
/// <param name="_modelsList"></param>
/// <returns></returns>
public bool Edit(FishEntity.BatchSheetEntity _model, List <FishEntity.BatchSheetsEntity> _modelsList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE t_batchsheet SET productionDate=@productionDate where code=@code");
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@productionDate", MySqlDbType.Date)
};
parameters [0].Value = _model.code;
parameters [1].Value = _model.productionDate;
SQLString.Add(strSql, parameters);
strSql = new StringBuilder( );
strSql.AppendFormat("SELECT id FROM t_batchsheets where code='{0}'", _model.code);
DataTable dt = MySqlHelper.Query(strSql.ToString( )).Tables [0];
foreach (FishEntity.BatchSheetsEntity model in _modelsList)
{
if (dt != null && dt.Rows.Count > 0 && dt.Select("id='" + model.id + "'").Length > 0)
{
edit(SQLString, strSql, model);
}
else
{
add(SQLString, strSql, model);
}
}
if (Exists_isDel(_model.code) == false)
{
if (dt != null && dt.Rows.Count > 0)
{
int id = 0;
FishEntity.BatchSheetsEntity model = new FishEntity.BatchSheetsEntity( );
for (int i = 0; i < dt.Rows.Count; i++)
{
id = string.IsNullOrEmpty(dt.Rows [i] ["id"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows [i] ["id"].ToString( ));
model = _modelsList.Find(x =>
{
return(x.id == id);
});
if (model == null)
{
delete(SQLString, strSql, id);
}
}
}
}
return(MySqlHelper.ExecuteSqlTran(SQLString));
}
public FishEntity.BatchSheetEntity getModel(DataRow row)
{
FishEntity.BatchSheetEntity model = new FishEntity.BatchSheetEntity( );
if (row != null)
{
if (row ["id"] != null && row ["id"].ToString( ) != "")
{
model.id = int.Parse(row ["id"].ToString( ));
}
if (row ["code"] != null)
{
model.code = row ["code"].ToString( );
}
if (row ["productionDate"] != null && row ["productionDate"].ToString( ) != "")
{
model.productionDate = DateTime.Parse(row ["productionDate"].ToString( ));
}
}
return(model);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_model"></param>
/// <param name="_modelsList"></param>
/// <returns></returns>
public bool Edit(FishEntity.BatchSheetEntity _model, List <FishEntity.BatchSheetsEntity> _modelsList)
{
return(dal.Edit(_model, _modelsList));
}
/// <summary>
/// 增加数据
/// </summary>
/// <param name="_model"></param>
/// <param name="_modelsList"></param>
/// <returns></returns>
public bool Add(FishEntity.BatchSheetEntity _model, List <FishEntity.BatchSheetsEntity> _modelsList, string name)
{
return(dal.Add(_model, _modelsList, name));
}
