/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FishEntity.CheckDetailEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_checkdetail(");
strSql.Append("mid,line,checkkey,checkvalue,orderid)");
strSql.Append(" values (");
strSql.Append("@mid,@line,@checkkey,@checkvalue,@orderid);");
strSql.Append("select LAST_INSERT_ID();");
MySqlParameter[] parameters =
{
new MySqlParameter("@mid", MySqlDbType.Int32, 11),
new MySqlParameter("@line", MySqlDbType.Int32, 11),
new MySqlParameter("@checkkey", MySqlDbType.VarChar, 100),
new MySqlParameter("@checkvalue", MySqlDbType.VarChar, 20),
new MySqlParameter("@orderid", MySqlDbType.Int32, 4)
};
parameters[0].Value = model.mid;
parameters[1].Value = model.line;
parameters[2].Value = model.checkkey;
parameters[3].Value = model.checkvalue;
parameters[4].Value = model.orderid;
int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters);
return(id);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FishEntity.CheckDetailEntity DataRowToModel(DataRow row)
{
FishEntity.CheckDetailEntity model = new FishEntity.CheckDetailEntity();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["mid"] != null && row["mid"].ToString() != "")
{
model.mid = int.Parse(row["mid"].ToString());
}
if (row["line"] != null && row["line"].ToString() != "")
{
model.line = int.Parse(row["line"].ToString());
}
if (row["checkkey"] != null)
{
model.checkkey = row["checkkey"].ToString();
}
if (row["checkvalue"] != null)
{
model.checkvalue = row["checkvalue"].ToString();
}
if (row["orderid"] != null && row["orderid"].ToString() != "")
{
model.orderid = int.Parse(row["orderid"].ToString());
}
}
return(model);
}
protected List <FishEntity.CheckDetailEntity> GetDetails(int mid)
{
if (_columns == null)
{
return(null);
}
dataGridView1.EndEdit();
List <FishEntity.CheckDetailEntity> listNews = new List <FishEntity.CheckDetailEntity>();
int lineidx = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.IsNewRow)
{
continue;
}
//int did = 0;
//if (row.Cells["id"].Value != null)
//{
// int.TryParse(row.Cells["id"].Value.ToString(), out did);
//}
lineidx = row.Index;
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
string colname = dataGridView1.Columns[i].Name;
FishEntity.DictEntity check = _columns.Find(k => { return(k.code.Equals(colname)); });
if (check == null)
{
continue;
}
string value = row.Cells[check.code].Value == null ? string.Empty : row.Cells[check.code].Value.ToString();
int did = 0;
if (row.Cells[check.code + "_id"].Value != null)
{
int.TryParse(row.Cells[check.code + "_id"].Value.ToString(), out did);
}
FishEntity.CheckDetailEntity item = new FishEntity.CheckDetailEntity();
item.mid = mid;
item.id = did;
item.checkkey = check.code;
item.checkvalue = value;
item.line = lineidx;
item.orderid = dataGridView1.Columns[i].Index;
listNews.Add(item);
}
}
return(listNews);
}
public List <FishEntity.CheckDetailEntity> GetCheckDetailVo(int productid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select a.productid,a.productcode,a.productname,a.checkunitid,a.checkunitcode,a.checkunit ,");
strSql.Append(" b.id , b.mid, b.line ,b.checkkey,b.checkvalue,b.orderid ");
strSql.Append(" from t_check a INNER join t_checkdetail b on a.id = b.mid");
strSql.Append(" where a.productid=" + productid);
DataSet ds = MySqlHelper.Query(strSql.ToString());
List <FishEntity.CheckDetailEntity> list = new List <FishEntity.CheckDetailEntity>();
int rowCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < rowCount; i++)
{
FishEntity.CheckDetailEntity model = DataRowToModel(ds.Tables[0].Rows[i]);
list.Add(model);
}
return(list);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FishEntity.CheckDetailEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_checkdetail set ");
strSql.Append("mid=@mid,");
strSql.Append("line=@line,");
strSql.Append("checkkey=@checkkey,");
strSql.Append("checkvalue=@checkvalue,");
strSql.Append("orderid=@orderid");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@mid", MySqlDbType.Int32, 11),
new MySqlParameter("@line", MySqlDbType.Int32, 11),
new MySqlParameter("@checkkey", MySqlDbType.VarChar, 100),
new MySqlParameter("@checkvalue", MySqlDbType.VarChar, 20),
new MySqlParameter("@orderid", MySqlDbType.Int32, 4),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.mid;
parameters[1].Value = model.line;
parameters[2].Value = model.checkkey;
parameters[3].Value = model.checkvalue;
parameters[4].Value = model.orderid;
parameters[5].Value = model.id;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FishEntity.CheckDetailEntity GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,mid,line,checkkey,checkvalue,orderid from t_checkdetail ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
FishEntity.CheckDetailEntity model = new FishEntity.CheckDetailEntity();
DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FishEntity.CheckDetailEntity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FishEntity.CheckDetailEntity model)
{
return(dal.Add(model));
}
