/// <summary>
/// 获得数据列表
/// </summary>
public List <Hownet.Model.MaterielType> DataTableToList(DataTable dt)
{
List <Hownet.Model.MaterielType> modelList = new List <Hownet.Model.MaterielType>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Hownet.Model.MaterielType model;
for (int n = 0; n < rowsCount; n++)
{
model = new Hownet.Model.MaterielType();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(dt.Rows[n]["ParentID"].ToString());
}
model.Name = dt.Rows[n]["Name"].ToString();
model.Sn = dt.Rows[n]["Sn"].ToString();
if (dt.Rows[n]["IsEnd"].ToString() != "")
{
model.IsEnd = int.Parse(dt.Rows[n]["IsEnd"].ToString());
}
if (dt.Rows[n]["IsUse"].ToString() != "")
{
if ((dt.Rows[n]["IsUse"].ToString() == "1") || (dt.Rows[n]["IsUse"].ToString().ToLower() == "true"))
{
model.IsUse = true;
}
else
{
model.IsUse = false;
}
}
model.Remark = dt.Rows[n]["Remark"].ToString();
if (dt.Rows[n]["AttributeID"].ToString() != "")
{
model.AttributeID = int.Parse(dt.Rows[n]["AttributeID"].ToString());
}
model.A = int.Parse(dt.Rows[n]["A"].ToString());
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.MaterielType model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.MaterielType model)
{
return(dal.Add(model));
}
public void AddBase()
{
List <Hownet.Model.MaterielType> li = DataTableToList(dal.GetList("(ID=0)").Tables[0]);
Hownet.Model.MaterielType modMT = new Hownet.Model.MaterielType();
modMT.ParentID = 0;
modMT.Name = "原材料";
modMT.Sn = "01";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 1;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 0;
modMT.Name = "半成品";
modMT.Sn = "02";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 2;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 0;
modMT.Name = "外加工";
modMT.Sn = "03";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 3;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 0;
modMT.Name = "成品";
modMT.Sn = "04";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 4;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 0;
modMT.Name = "商标";
modMT.Sn = "05";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 5;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 1;
modMT.Name = "钢弓";
modMT.Sn = "0101";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 1;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 1;
modMT.Name = "透明背带";
modMT.Sn = "0102";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 1;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 2;
modMT.Name = "棉碗";
modMT.Sn = "0201";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 2;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 2;
modMT.Name = "成品肩带";
modMT.Sn = "0202";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 2;
modMT.Remark = "";
Add(modMT);
modMT.ParentID = 1;
modMT.Name = "胶骨";
modMT.Sn = "0103";
modMT.IsEnd = 0;
modMT.IsUse = true;
modMT.AttributeID = 1;
modMT.Remark = "";
Add(modMT);
}
