public string RemoveConnect31(Connect3 connect3) // 表中删除一行
{
try
{
SqlConnection conn = new SqlConnection(DbUtil.ConnString);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = DbUtil.connect3DataBasesql6;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@departmentNumber", connect3.DepartmentNumber));
conn.Open(); //打开数据链接
SqlDataReader reader = cmd.ExecuteReader();
conn.Close();
}
catch (Exception ee)
{
exception = ee.ToString();
//Console.WriteLine(ee.ToString());
}
//Console.WriteLine(image.ToString());
return(exception);
}
/*private void change_Click(object sender, EventArgs e)
* {
* //Form2 f2 = new Form2();//子窗体
* //f2.MdiParent = this;
* //f2.Show();
* outtextbox_ImageNumber.ReadOnly = false;
* outtextbox_PartsName.ReadOnly = false;
* outtextbox_CompanyName.ReadOnly = false;
* outtextbox_CompanyNumber.ReadOnly = false;
* outtextbox_ProductName.ReadOnly = false;
* outtextbox_ProductType.ReadOnly = false;
* }
* private void ok_Click(object sender, EventArgs e)
* {
* Images img = new Images();
* img.ImageNumber = outtextbox_ImageNumber.Text;
* img.PartsName = outtextbox_PartsName.Text;
* string strCompanyName = outtextbox_CompanyName.Text;
* string strCompanyNumber = outtextbox_CompanyNumber.Text;
* string strProductName = outtextbox_ProductName.Text;
* string strProductType = outtextbox_ProductType.Text;
*
* //... ...
* }*/
private void ok_Click(object sender, EventArgs e)
{
Images image = new Images();
Connect1 c1 = new Connect1();
Connect2 c2 = new Connect2();
Connect3 c3 = new Connect3();
ImageManager iManager = new ImageManager();
Connect1Manager c1Manager = new Connect1Manager();
Connect2Manager c2Manager = new Connect2Manager();
Connect3Manager c3Manager = new Connect3Manager();
image.ImageNumber = outtextbox_ImageNumber.Text.Trim();
image.PartsName = outtextbox_PartsName.Text;
c1.ImageNumber = image.ImageNumber;
c1.ProductType = outtextbox_ProductType.Text;
c2.ImageNumber = image.ImageNumber;
c2.CompanyNumber = outtextbox_CompanyNumber.Text;
c3.ImageNumber = image.ImageNumber;
iManager.DeleteImage(image);
c1Manager.DeleteConnect1(c1);
c2Manager.DeleteConnect2(c2);
c3Manager.DeleteConnect3(c3);
}
public List <Connect3> GetConnect3(Images img) //部门选择判断
{
List <Connect3> c3List = new List <Connect3>();
if (DepartmentName1.Checked == true)
{
Connect3 c3 = new Connect3();
c3.DepartmentNumber = "11";
c3.ImageNumber = img.ImageNumber;
c3List.Add(c3);
}
if (DepartmentName2.Checked == true)
{
Connect3 c3 = new Connect3();
c3.DepartmentNumber = "12";
c3.ImageNumber = img.ImageNumber;
c3List.Add(c3);
}
if (DepartmentName3.Checked == true)
{
Connect3 c3 = new Connect3();
c3.DepartmentNumber = "13";
c3.ImageNumber = img.ImageNumber;
c3List.Add(c3);
}
if (!(DepartmentName1.Checked || DepartmentName2.Checked || DepartmentName3.Checked))
{
MessageBox.Show("请至少选择一个发放部门！");
}
return(c3List);
}
public List <Connect3> SearchConnect(Connect3 c3)
{
List <Connect3> tempList = null;
if (c3 != null)
{
tempList = c3DAO.SelectConnect3(c3);
}
return(tempList);
}
public List <Connect3> SearchConnect3(Connect3 c3, string judge)
{
List <Connect3> tempList = null;
if (judge == "imageNumber")
{
tempList = c3DAO.SelectConnect311(c3.ImageNumber);
}
else
{
tempList = c3DAO.SelectConnect31(c3.DepartmentNumber);
}
return(tempList);
}
public bool AlterConnect3(Connect3 c3)
{
bool flag = false;
if (c3DAO.SelectConnect3(c3) != null)
{
c3DAO.UpdateConnect3(c3);
flag = true;
}
else
{
flag = false;
}
return(flag);
}
public bool GetDepartmentManage(Images image, string tempDepartment)
{
bool flag = false;
Connect3Manager c3Manager = new Connect3Manager();
Connect3 c3 = new Connect3();
List <Connect3> c3List = new List <Connect3>();
c3.DepartmentNumber = tempDepartment;
c3.ImageNumber = image.ImageNumber;
c3List = c3Manager.SearchConnect(c3);
for (int i = 0; i < c3List.Count; i++)
{
if (tempDepartment == c3List[i].DepartmentNumber)
{
flag = true;
}
}
return(flag);
}
public List <Connect3> GetConnect3(Images img) //部门选择判断
{
List <Connect3> c3List = new List <Connect3>();
Connect3 c3 = new Connect3();
for (int i = 0; i < LvsModifyDeportments.CheckedItems.Count; i++)
{
if (LvsModifyDeportments.CheckedItems[i].Checked)
{
c3.DepartmentNumber = LvsModifyDeportments.CheckedItems[i].SubItems[2].Text;
}
c3.ImageNumber = img.ImageNumber;
c3List.Add(c3);
c3 = null;
}
return(c3List);
}
public List <Connect3> SelectConnect311(string imageNumber) //根据 ui 选择返回一个image
{
Connect3 temp = null;
List <Connect3> connect3List = null;
try
{
SqlConnection conn = new SqlConnection(DbUtil.ConnString);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = DbUtil.connect3DataBasesql7;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@imageNumber", imageNumber));
conn.Open(); //打开数据链接
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()) //开始读取数据
{
temp.ImageNumber = reader.GetString(reader.GetOrdinal("imageNumber"));
temp.DepartmentNumber = reader.GetString(reader.GetOrdinal("departmentNumber"));
connect3List.Add(temp);
}
conn.Close();
}
catch (Exception ee)
{
exception = ee.ToString();
//Console.WriteLine(ee.ToString());
}
//Console.WriteLine(image.ToString());
return(connect3List);
}
public bool DeleteConnect3(Connect3 c3)
{
bool flag = false;
if (iDAO.SelectImage(c3.ImageNumber) != null)
{
c3DAO.RemoveConnect3(c3);
flag = true;
}
/*else if (pDAO.SelectProduct(c3.ProductType) == null)
* {
* c3DAO.RemoveConnect31(c3);
* flag = true;
* }*/
else
{
flag = false;
}
return(flag);
}
