private void button1_Click(object sender, EventArgs e)
{
try
{
decimal aaa = Convert.ToDecimal(textBox1.Text.Trim());
decimal bbbb = Convert.ToDecimal(textBox2.Text.Trim());
}
catch
{
MessageBox.Show("换算率只能是数字");
return;
}
Hownet.Model.OtherType modOT = bllOT.GetModel(Convert.ToInt32(Convert.ToInt32(dtOT.Select("(Name='默认单位')")[0]["ID"])));
modOT.Value = comboBox1.SelectedValue.ToString();
bllOT.Update(modOT);
modOT = bllOT.GetModel(Convert.ToInt32(Convert.ToInt32(dtOT.Select("(Name='车间单位')")[0]["ID"])));
modOT.Value = comboBox2.SelectedValue.ToString();
bllOT.Update(modOT);
modOT = bllOT.GetModel(Convert.ToInt32(Convert.ToInt32(dtOT.Select("(Name='仓储单位')")[0]["ID"])));
modOT.Value = comboBox3.SelectedValue.ToString();
bllOT.Update(modOT);
modOT = bllOT.GetModel(Convert.ToInt32(Convert.ToInt32(dtOT.Select("(Name='车间换算')")[0]["ID"])));
modOT.Value = textBox1.Text.Trim();
bllOT.Update(modOT);
modOT = bllOT.GetModel(Convert.ToInt32(Convert.ToInt32(dtOT.Select("(Name='仓储换算')")[0]["ID"])));
modOT.Value = textBox2.Text.Trim();
bllOT.Update(modOT);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.OtherType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OtherType(");
strSql.Append("Name,TypeID,Value)");
strSql.Append(" values (");
strSql.Append("@Name,@TypeID,@Value)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@Value", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.TypeID;
parameters[2].Value = model.Value;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hownet.Model.OtherType GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,TypeID,Value from OtherType ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Hownet.Model.OtherType model = new Hownet.Model.OtherType();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["TypeID"].ToString() != "")
{
model.TypeID = int.Parse(ds.Tables[0].Rows[0]["TypeID"].ToString());
}
model.Value = ds.Tables[0].Rows[0]["Value"].ToString();
model.A = 1;
return(model);
}
else
{
return(null);
}
}
private void frFinishedMeasure_Load(object sender, EventArgs e)
{
dtMea = bllMea.GetAllList().Tables[0];
comboBox1.DataSource = dtMea.Copy();
comboBox2.DataSource = dtMea.Copy();
comboBox3.DataSource = dtMea.Copy();
dtOT = bllOT.GetTypeList("成品单位").Tables[0];
if (dtOT.Rows.Count == 0)
{
Hownet.Model.OtherType modOT = new Hownet.Model.OtherType();
modOT.A = 1;
modOT.Name = "成品单位";
modOT.TypeID = 0;
modOT.Value = "0";
int _id = bllOT.Add(modOT);
modOT.TypeID = _id;
modOT.Name = "默认单位";
modOT.Value = "1";
bllOT.Add(modOT);
modOT.TypeID = _id;
modOT.Name = "仓储单位";
bllOT.Add(modOT);
modOT.TypeID = _id;
modOT.Name = "仓储换算";
bllOT.Add(modOT);
modOT.TypeID = _id;
modOT.Name = "车间单位";
bllOT.Add(modOT);
modOT.TypeID = _id;
modOT.Name = "车间换算";
bllOT.Add(modOT);
dtOT = bllOT.GetTypeList("成品单位").Tables[0];
}
li = bllOT.DataTableToList(dtOT);
comboBox1.SelectedValue = Convert.ToInt32(dtOT.Select("(Name='默认单位')")[0]["Value"]);
comboBox2.SelectedValue = Convert.ToInt32(dtOT.Select("(Name='车间单位')")[0]["Value"]);
comboBox3.SelectedValue = Convert.ToInt32(dtOT.Select("(Name='仓储单位')")[0]["Value"]);
textBox1.Text = dtOT.Select("(Name='车间换算')")[0]["Value"].ToString();
textBox2.Text = dtOT.Select("(Name='仓储换算')")[0]["Value"].ToString();
if (bllPA.GetAllList().Tables[0].Rows.Count > 0)
{
comboBox1.Enabled = comboBox2.Enabled = comboBox3.Enabled = false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.OtherType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OtherType set ");
strSql.Append("Name=@Name,");
strSql.Append("TypeID=@TypeID,");
strSql.Append("Value=@Value");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@Value", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
parameters[2].Value = model.TypeID;
parameters[3].Value = model.Value;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
