private void butInsertSQL_Click(object sender, EventArgs e)
{
if (!flag)
{
MessageBox.Show("待插入的数据为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
bool temp = false;
for (int i = 0; i <= index; i++)
{
SqlParameter[] paraValues =
{
new SqlParameter("@StaffNum", SqlDbType.Char),
new SqlParameter("@StaffName", SqlDbType.Char),
new SqlParameter("@StaffSex", SqlDbType.Char),
new SqlParameter("@StaffTime", SqlDbType.DateTime),
new SqlParameter("@StaffDuty", SqlDbType.Char)
};
for (int j = 0; j < 5; j++)
{
paraValues[j].Value = setStaffMessage.Rows[i].Cells[j].Value.ToString();
}
temp = Manipulation.Manipulation.insertStoredProcedure("Insert_Staff", paraValues);
}
if (temp)
{
MessageBox.Show("所有数据插入成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
InformationManage.clear(setStaffMessage);
}
}
private void butCancel_Click(object sender, EventArgs e)
{
if (index <= 0)
{
flag = false;
InformationManage.clear(setStaffMessage);
}
else
{
InformationManage.remove(setStaffMessage, index);
index--;
}
}
private void butAdd_Click(object sender, EventArgs e)
{
string[] values = { cusNum.Text, cusName.Text, cusTell.Text };
if (InformationManage.isEmpty(values))
{
index = setCusMessage.Rows.Add();
flag = true;
InformationManage.insert(values, setCusMessage, index);
}
else
{
MessageBox.Show("请将信息填写完整！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/**
* 加入按钮点击事件
*/
private void butAdd_Click(object sender, System.EventArgs e)
{
string[] values = { drugNum.Text, customerNum.Text, drugPrice.Text, supplyNum.Text, orderTime.Value.ToString() };
if (InformationManage.isEmpty(values))
{
index = setDrugMessage.Rows.Add();
flag = true;
InformationManage.insert(values, setDrugMessage, index);
}
else
{
MessageBox.Show("请将信息填写完整！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butAdd_Click(object sender, EventArgs e)
{
string[] values = { drugNum.Text, drugName.Text, birthday.Value.ToString(), validity.Value.ToString(), drugFunction.Text,
supplierNum.Text, supplierPrice.Text, supplyNum.Text, supplyTime.Value.ToString() };
if (InformationManage.isEmpty(values))
{
index = setPurchaseMessage.Rows.Add();
flag = true;
InformationManage.insert(values, setPurchaseMessage, index);
}
else
{
MessageBox.Show("请将信息填写完整！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butInsertSQL_Click(object sender, EventArgs e)
{
if (!flag)
{
MessageBox.Show("待插入的数据为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
bool temp = false;
for (int i = 0; i <= index; i++)
{
SqlParameter[] paraValues =
{
new SqlParameter("@DrugNum", SqlDbType.Char),
new SqlParameter("@DrugName", SqlDbType.Char),
new SqlParameter("@Birthday", SqlDbType.Char),
new SqlParameter("@Validity", SqlDbType.Char),
new SqlParameter("@DrugFunction", SqlDbType.Char),
new SqlParameter("@SupplierNum", SqlDbType.Char),
new SqlParameter("@SupplierPrice", SqlDbType.Char),
new SqlParameter("@SupplyNum", SqlDbType.Char),
new SqlParameter("@SupplyTime", SqlDbType.Char)
};
for (int j = 0; j < 9; j++)
{
paraValues[j].Value = setPurchaseMessage.Rows[i].Cells[j].Value.ToString();
}
temp = Manipulation.Manipulation.insertStoredProcedure("Insert_SupplierShip", paraValues);
if (temp)
{
SqlParameter[] MinusParaValues =
{
new SqlParameter("@DrugNum", SqlDbType.Char),
new SqlParameter("@SupplyNum", SqlDbType.Int)
};
MinusParaValues[0].Value = setPurchaseMessage.Rows[i].Cells[0].Value.ToString();
MinusParaValues[1].Value = setPurchaseMessage.Rows[i].Cells[7].Value.ToString();
Manipulation.Manipulation.insertStoredProcedure("Add_Drug", MinusParaValues);
temp = false;
}
}
if (temp)
{
MessageBox.Show("所有数据插入成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
InformationManage.clear(setPurchaseMessage);
}
}
/**
* 插入数据库按钮点击事件
*/
private void butInsertSQL_Click(object sender, System.EventArgs e)
{
if (!flag)
{
MessageBox.Show("待插入的数据为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
bool temp = false;
for (int i = 0; i <= index; i++)
{
SqlParameter[] insertParaValues =
{
new SqlParameter("@DrugNum", SqlDbType.Char),
new SqlParameter("@CustomerNum", SqlDbType.Char),
new SqlParameter("@DemandPrice", SqlDbType.Real),
new SqlParameter("@DemandNum", SqlDbType.Int),
new SqlParameter("@DamandTime", SqlDbType.DateTime),
};
for (int j = 0; j < 5; j++)
{
insertParaValues[j].Value = setDrugMessage.Rows[i].Cells[j].Value.ToString();
}
temp = Manipulation.Manipulation.insertStoredProcedure("Insert_DemandShip", insertParaValues);
if (temp)
{
SqlParameter[] MinusParaValues =
{
new SqlParameter("@DrugNum", SqlDbType.Char),
new SqlParameter("@DemandNum", SqlDbType.Int)
};
MinusParaValues[0].Value = setDrugMessage.Rows[i].Cells[0].Value.ToString();
MinusParaValues[1].Value = setDrugMessage.Rows[i].Cells[3].Value.ToString();
Manipulation.Manipulation.insertStoredProcedure("Minus_Drug", MinusParaValues);
temp = false;
}
}
if (temp)
{
MessageBox.Show("所有数据插入成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
InformationManage.clear(setDrugMessage);
}
}
private void butAdd_Click(object sender, EventArgs e)
{
string sex = "";
if (radioMan.Checked)
{
sex = "男";
}
if (radioWom.Checked)
{
sex = "女";
}
string[] values = { staffNum.Text, staffName.Text, sex, staffTime.Value.ToString(), staffDuty.Text };
if (InformationManage.isEmpty(values))
{
flag = true;
index = setStaffMessage.Rows.Add();
InformationManage.insert(values, setStaffMessage, index);
}
else
{
MessageBox.Show("请将信息填写完整！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}