/// <summary>
/// 保存数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateControls())
{
MessageBox.Show("输入不能为空，请核查!");
return;
}
DataRow dr = dtZyInfo.Rows[0];
dr["ylzh"] = this.tbMcard.Text.Trim();
dr["name"] = this.tbName.Text.Trim();
dr["zyh"] = this.tbInhosNum.Text.Trim();
bool result = new Business.ItemProcess().UpdateZyjl(dtZyInfo);
if (result)
{
MessageBox.Show(this, "修改成功!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
((InhosList)this.Owner).loadDataByStr();
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show(this, "保存失败!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void GetDetails()
{
Hashtable ht = new Hashtable();
ht.Add("id", "1");
DataTable dt = new Business.ItemProcess().GetDetailById(ht).Tables[0];
this.DetailGridView.AutoGenerateColumns = false;
this.DetailGridView.DataSource = dt;
}
private void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = (DataTable)this.DetailGridView.DataSource;
bool result = new Business.ItemProcess().UpdateDetailInfo(dt);
if (result)
{
MessageBox.Show("保存成功!");
}
}
/// <summary>
/// 通过scanname showname 获取,加载数据的时候，两个值相等
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private Hashtable getItemDictRowByScanName(string data)
{
Hashtable ht = new Hashtable();
int count = 0;
string centercode = "";
string firstCenterCode = "";
string showname = "";
DataTable dtItemDict = null;
//改成存储过程
DataSet ds = new Business.ItemProcess().GetItemDict(this.frcode, data);
if (ds.Tables.Count > 0)
{
dtItemDict = ds.Tables[0];
if (dtItemDict.Rows.Count > 0)
{
DataRow dr = dtItemDict.Rows[0];
centercode = dr["centercode"] == null ? "" : dr["centercode"].ToString();
showname = dr["showname"] == null ? "" : dr["showname"].ToString();
if (!String.IsNullOrEmpty(centercode))
{
if (String.IsNullOrEmpty(firstCenterCode))
{
firstCenterCode = centercode;
}
}
}
}
if (!String.IsNullOrEmpty(firstCenterCode))
{
DataSet dsDict = new Business.DictProcess().GetItemByID(firstCenterCode);
if (dsDict.Tables.Count > 0)
{
DataTable dtDict = dsDict.Tables[0];
if (dtDict.Rows.Count > 0)
{
ScanDataSet.CenterDataRow centerDataRow = (ScanDataSet.CenterDataRow)dtDict.Rows[0];
ht.Add("row", centerDataRow);
return(ht);
}
}
}
return(ht);
}
private void GetDetailById(string id)
{
this.ScanDataGridView.AutoGenerateColumns = false;
this.ScanDataGridView.DataSource = null;
Hashtable ht = new Hashtable();
ht.Add("id", id);
DataTable dt = new Business.ItemProcess().GetDetailById(ht).Tables[0];
this.labelCount.Text = "总条数：0";
this.labelTotalPrice.Text = "总金额：0";
if (dt.Rows.Count > 0)
{
this.ScanDataGridView.DataSource = dt;
this.Text += this.treeView1.SelectedNode.Text;
}
}
private void save(string id)
{
if (this.ScanDataGridView.Rows.Count > 1)
{
try
{
DataTable dt = (DataTable)this.ScanDataGridView.DataSource;
//循环处理数据
bool result = true;
int rowcount = dt.Rows.Count;
//获取保存在dataset中的数据
if (dt.Rows.Count > 1)
{
//可能会有gridview 数据多，dataset 数据少，数据源没刷新的情况
this.ScanDataGridView.EndEdit();
((IEditableObject)this.ScanDataGridView.CurrentRow.DataBoundItem).EndEdit();
this.ScanDataGridView.CurrentCell = null;
Application.DoEvents();
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["pid"] = id;
dt.Rows[i]["paydate"] = System.DateTime.Now.ToShortDateString();
string code = dt.Rows[i]["code"] == null?i.ToString() : dt.Rows[i]["code"].ToString();
if (String.IsNullOrEmpty(code))
{
dt.Rows[i]["code"] = i.ToString();
}
string detailGUID = dt.Rows[i]["DetailGUID"] == null?Guid.NewGuid().ToString() : dt.Rows[i]["DetailGUID"].ToString();
if (String.IsNullOrEmpty(detailGUID))
{
dt.Rows[i]["DetailGUID"] = Guid.NewGuid().ToString();
}
string centercode = dt.Rows[i]["centercode"] == null?i.ToString() : dt.Rows[i]["centercode"].ToString();
string itemname = dt.Rows[i]["name"] == null ? "" : dt.Rows[i]["name"].ToString();
if (String.IsNullOrEmpty(centercode))
{
MessageBox.Show("中心编码不能为空!项目名称:【" + itemname + "】");
return;
}
string centername = "";
DataTable dtname = new Business.DictProcess().GetItemByID(centercode).Tables[0];
if (dtname.Rows.Count > 0)
{
centername = dtname.Rows[0]["name"].ToString();
}
dt.Rows[i]["centername"] = centername;
}
result = new Business.ItemProcess().SaveAndUpdateDetail(dt);
if (result)
{
this.loadForm.DialogResult = DialogResult.OK;
MessageBox.Show("保存成功");
}
}
}
catch (Exception ex)
{
showError(ex.ToString());
}
}
}