/// <summary>
/// 方法说明：根据Id更新材料定额数据
/// 作 者：jason.tang
/// 完成时间：2013-07-09
/// </summary>
/// <param name="materialQuota">材料定额实体</param>
/// <returns></returns>
public static bool UpdateQuotaData(MaterialQuota materialQuota)
{
bool result = false;
try
{
string strsql = @"update MaterialQuota set
Quota=@Quota
where
Id=@Id";
using (DbCommand cmd = db.GetSqlStringCommand(strsql))
{
if (materialQuota.Quota == decimal.MinValue)
{
db.AddInParameter(cmd, "@Quota", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(cmd, "@Quota", DbType.Decimal, materialQuota.Quota);
}
db.AddInParameter(cmd, "@Id", DbType.Guid, materialQuota.Id);
result = db.ExecuteNonQuery(cmd) > 0;
}
}
catch
{
throw;
}
return(result);
}
/// <summary>
/// 方法说明：根据Id更新材料定额数据
/// 作 者：jason.tang
/// 完成时间：2013-07-09
/// </summary>
/// <param name="materialQuota">材料定额实体</param>
/// <returns></returns>
public static bool UpdateMaterialQuotaData(MaterialQuota materialQuota)
{
bool result = false;
try
{
string strsql = @"update MaterialQuota set
Proportion=@Proportion,
ValidDigits=@ValidDigits,
Formula=@Formula
where
Id=@Id";
using (DbCommand cmd = db.GetSqlStringCommand(strsql))
{
db.AddInParameter(cmd, "@Proportion", DbType.Decimal, materialQuota.Proportion);
db.AddInParameter(cmd, "@ValidDigits", DbType.Int32, materialQuota.ValidDigits);
db.AddInParameter(cmd, "@Formula", DbType.String, materialQuota.Formula);
db.AddInParameter(cmd, "@Id", DbType.Guid, materialQuota.Id);
result = db.ExecuteNonQuery(cmd) > 0;
}
}
catch
{
throw;
}
return(result);
}
/// <summary>
/// 计算材料定额
/// </summary>
private void btnCalc_Click(object sender, EventArgs e)
{
if (dgvMaterialQuota.CurrentRow == null)
{
return;
}
//string quota = Calc();
//if (string.IsNullOrEmpty(quota))
// return;
List <MaterialQuota> listOldMaterialQuota = new List <MaterialQuota>();
List <MaterialQuota> listNewMaterialQuota = new List <MaterialQuota>();
foreach (DataGridViewRow row in dgvMaterialQuota.Rows)
{
string id = row.Cells["Id"].Value.ToString();
bool isNew = false;
if (string.IsNullOrEmpty(id))
{
id = Guid.NewGuid().ToString();
isNew = true;
}
materialQuota = new MaterialQuota();
decimal meterWeight = decimal.Parse(row.Cells["colMeterWeight"].Value.ToString());
decimal quota = decimal.Parse(row.Cells["colChildCount"].Value.ToString()) * meterWeight;
dgvMaterialQuota.CurrentRow.Cells["colMaterialQuota"].Value = quota;
materialQuota.Quota = quota;
materialQuota.Id = new Guid(id);
if (isNew)
{
materialQuota.Code = row.Cells["colCode"].Value.ToString();
listNewMaterialQuota.Add(materialQuota);
}
else
{
listOldMaterialQuota.Add(materialQuota);
}
}
foreach (MaterialQuota material in listOldMaterialQuota)
{
bool result = MaterialQuotaBLL.UpdateQuotaData(material);
}
foreach (MaterialQuota material in listNewMaterialQuota)
{
bool result = MaterialQuotaBLL.AddMaterialQuotaData(material);
}
LoadData(MaterialVerId);
}
/// <summary>
/// 方法说明：根据Id更新材料定额数据
/// 作 者：jason.tang
/// 完成时间：2013-07-27
/// </summary>
/// <param name="materialQuota">材料定额实体</param>
/// <returns></returns>
public static bool UpdateQuotaData(MaterialQuota materialQuota)
{
bool result = false;
try
{
result = MaterialQuotaDAL.UpdateQuotaData(materialQuota);
}
catch
{
throw;
}
return(result);
}
/// <summary>
/// 修改
/// </summary>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (dgvMaterialQuota.CurrentRow == null || !CheckInput())
{
return;
}
string id = dgvMaterialQuota.CurrentRow.Cells["Id"].Value.ToString();
int rowIndex = dgvMaterialQuota.CurrentRow.Index;
materialQuota = new MaterialQuota();
materialQuota.Proportion = decimal.Parse(txtProportion.Text);
materialQuota.ValidDigits = int.Parse(txtValidDigits.Text);
materialQuota.Formula = txtFormula.Text;
materialQuota.Id = new Guid(id);
bool result = MaterialQuotaBLL.UpdateMaterialQuotaData(materialQuota);
if (result)
{
_keyWords["Proportion"] = materialQuota.Proportion.ToString();
_keyWords["ValidDigits"] = materialQuota.ValidDigits.ToString();
_keyWords["Formula"] = materialQuota.Formula.ToString();
string quota = Calc();
if (string.IsNullOrEmpty(quota))
{
return;
}
materialQuota.Quota = string.IsNullOrEmpty(quota) ? decimal.MinValue : decimal.Parse(quota);
MaterialQuotaBLL.UpdateQuotaData(materialQuota);
LoadData(MaterialVerId);
dgvMaterialQuota.ClearSelection();
MessageBox.Show("材料定额修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
dgvMaterialQuota.Rows[rowIndex].Selected = true;
}
/// <summary>
/// 方法说明：新增材料定额数据
/// 作 者：jason.tang
/// 完成时间：2013-07-10
/// </summary>
/// <param name="materialQuota">材料定额实体</param>
/// <returns></returns>
public static bool AddMaterialQuotaData(MaterialQuota materialQuota)
{
bool result = false;
try
{
string strsql = @"INSERT INTO MaterialQuota
([Id]
,[Code]
,[Proportion]
,[ValidDigits]
,[Formula]
,[Quota])
VALUES
(
@ID
,@Code
,@Proportion
,@ValidDigits
,@Formula
,@Quota)";
using (DbCommand cmd = db.GetSqlStringCommand(strsql))
{
db.AddInParameter(cmd, "@Id", DbType.Guid, materialQuota.Id);
db.AddInParameter(cmd, "@Code", DbType.String, materialQuota.Code);
db.AddInParameter(cmd, "@Proportion", DbType.Decimal, materialQuota.Proportion);
db.AddInParameter(cmd, "@ValidDigits", DbType.Int32, materialQuota.ValidDigits);
db.AddInParameter(cmd, "@Formula", DbType.String, materialQuota.Formula);
db.AddInParameter(cmd, "@Quota", DbType.Decimal, materialQuota.Quota);
result = db.ExecuteNonQuery(cmd) > 0;
}
}
catch
{
throw;
}
return(result);
}
/// <summary>
/// 新增
/// </summary>
private void btnAdd_Click(object sender, EventArgs e)
{
if (dgvMaterialQuota.CurrentRow == null || !CheckInput())
{
return;
}
materialQuota = new MaterialQuota();
materialQuota.Proportion = decimal.Parse(txtProportion.Text);
materialQuota.ValidDigits = int.Parse(txtValidDigits.Text);
materialQuota.Formula = txtFormula.Text;
materialQuota.Id = Guid.NewGuid();
materialQuota.Code = dgvMaterialQuota.CurrentRow.Cells["colCode"].Value.ToString();
bool result = MaterialQuotaBLL.AddMaterialQuotaData(materialQuota);
if (result)
{
LoadData(MaterialVerId);
dgvMaterialQuota.ClearSelection();
MessageBox.Show("材料定额信息新增成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvMaterialQuota.Rows[dgvMaterialQuota.Rows.Count - 1].Selected = true;
}
}
