private void ly_sales_profit_sumDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (null == dgv.CurrentRow)
{
return;
}
////////////////////////////////////////
if ("业务费用因子" == dgv.CurrentCell.OwningColumn.Name || "利润率基值" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.setInFocus();
queryForm.ShowDialog(this);
if (queryForm.NewValue != "")
{
////////////////////////////////////////////////
string updstr;
if ("业务费用因子" == dgv.CurrentCell.OwningColumn.Name)
{
updstr = " update ly_sales_profit_arrt set buseness_arrt = " + queryForm.NewValue;
}
else
{
updstr = " update ly_sales_profit_arrt set profit_arrt = " + queryForm.NewValue;
}
SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = updstr;
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
cmd.CommandTimeout = 0;
using (TransactionScope scope = new TransactionScope())
{
sqlConnection1.Open();
try
{
cmd.ExecuteNonQuery();
scope.Complete();
}
catch (SqlException sqle)
{
MessageBox.Show(sqle.Message.Split('*')[0]);
}
finally
{
sqlConnection1.Close();
}
}
}
else
{
}
this.ly_sales_profit_sumTableAdapter.Fill(this.lYSalseMange2.ly_sales_profit_sum, this.dateTimePicker9.Value, this.dateTimePicker10.Value.AddDays(1));
return;
}
/////////////////////////////////////////////////////
}
private void ly_payable_NPDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (null == dgv.CurrentRow)
{
return;
}
if (!SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "非采购供应商账款删除"))
{
MessageBox.Show("无修改权限", "注意");
return;
}
else
{
string salespeople = dgv.CurrentRow.Cells["录入人"].Value.ToString();
if (!string.IsNullOrEmpty(salespeople))
{
if (salespeople != SQLDatabase.nowUserName())
{
MessageBox.Show("请录入人:" + salespeople + "修改", "注意");
return;
}
}
}
if ("录入日期" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "datetime";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["录入日期"].Value = queryForm.NewValue;
ly_payable_NPBindingSource.EndEdit();
ly_payable_NPTableAdapter.Update(this.lYFinancialMange.ly_payable_NP);
}
else
{
// dgv.CurrentRow.Cells["支付日期pre"].Value = DBNull.Value;
}
return;
}
////////////////////////////////////////////////////////////////////////
/////////////////////////////
if ("备注pay" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["备注pay"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
ly_payable_NPBindingSource.EndEdit();
ly_payable_NPTableAdapter.Update(this.lYFinancialMange.ly_payable_NP);
}
else
{
}
return;
}
///////////////////////////////////////////////////////////////
if ("应付金额" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.setInFocus();
queryForm.ShowDialog(this);
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["应付金额"].Value = queryForm.NewValue;
ly_payable_NPBindingSource.EndEdit();
ly_payable_NPTableAdapter.Update(this.lYFinancialMange.ly_payable_NP);
}
else
{
//hT_Manage_ItemDataGridView.CurrentRow.Cells["apply_money"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["apply_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
//SaveChanged();
}
return;
}
}
