public int InsertRemoveHornInfo(RemoveHorn removeHorn)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into [1mutong].[dbo].[Medical_RemoveHorn] values (
" + removeHorn.EarNum + ",'"
+ removeHorn.Method + "','"
+ removeHorn.OprateDate + "')");
return(dataProvider1mutong.ExecuteNonQuery(sql.ToString(), CommandType.Text));
}
public List <RemoveHorn> GetRemoveHornList()
{
List <RemoveHorn> lstRemoveHorn = new List <RemoveHorn>();
DataTable datRemoveHorn = this.dalRemoveHorn.GetRemoveHornList();
foreach (DataRow drRemoveHorn in datRemoveHorn.Rows)
{
RemoveHorn removeHornItem = WrapRemoveHornItem(drRemoveHorn);
lstRemoveHorn.Add(removeHornItem);
}
return(lstRemoveHorn);
}
private RemoveHorn WrapRemoveHornItem(DataRow removeHornRow)
{
RemoveHorn removeHornItem = new RemoveHorn();
if (removeHornRow != null)
{
if (Convert.ToInt32(removeHornRow["ID"]) != 0)
{
removeHornItem.ID = Convert.ToInt32(removeHornRow["ID"]);
}
if (Convert.ToInt32(removeHornRow["EarNum"]) != 0)
{
removeHornItem.EarNum = Convert.ToInt32(removeHornRow["EarNum"]);
}
removeHornItem.Method = removeHornRow["Method"].ToString();
removeHornItem.OprateDate = Convert.ToDateTime(removeHornRow["OprateDate"]);
}
return(removeHornItem);
}
public int InsertRemoveHornInfo(RemoveHorn removeHorn)
{
return(dalRemoveHorn.InsertRemoveHornInfo(removeHorn));
}
