public string RemoveConnect21(Connect2 connect2) //删除表中某行
{
try
{
SqlConnection conn = new SqlConnection(DbUtil.ConnString);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = DbUtil.connect2DataBasesql6;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@companyNumber", connect2.CompanyNumber));
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 <Connect2> SearchConnect(Connect2 c2)
{
List <Connect2> tempList = null;
if (c2 != null)
{
tempList = c2DAO.SelectConnect2(c2);
}
return(tempList);
}
public List <Connect2> GetConnect2(Images img, List <Company> tempList) //公司选择判断
{
List <Connect2> c2List = new List <Connect2>();
for (int i = 0; i < tempList.Count; i++)
{
Connect2 c2 = new Connect2();
c2.CompanyNumber = tempList[i].CompanyNumber;
c2.ImageNumber = img.ImageNumber;
c2List.Add(c2);
}
return(c2List);
}
public List <Connect2> SearchConnect2(Connect2 c2, string judge)
{
List <Connect2> tempList = null;
if (judge == "imageNumber")
{
tempList = c2DAO.SelectConnect211(c2.ImageNumber);
}
else
{
tempList = c2DAO.SelectConnect21(c2.CompanyNumber);
}
return(tempList);
}
public bool AlterConnect2(Connect2 c2)
{
bool flag = false;
if (c2DAO.SelectConnect2(c2) != null)
{
c2DAO.UpdateConnect2(c2);
flag = true;
}
else
{
flag = false;
}
return(flag);
}
public bool DeleteConnect2(Connect2 c2)
{
bool flag = false;
if (iDAO.SelectImage(c2.ImageNumber) != null)
{
c2DAO.RemoveConnect2(c2);
flag = true;
}
/*else if (pDAO.SelectProduct(c2.CompanyNumber) == null)
* {
* c2DAO.RemoveConnect21(c2);
* flag = true;
* }*/
else
{
flag = false;
}
return(flag);
}
public List <Connect2> SelectConnect211(string imageNumber) //查
{
Connect2 temp = null;
List <Connect2> connect2List = null;
try
{
SqlConnection conn = new SqlConnection(DbUtil.ConnString);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = DbUtil.connect2DataBasesql7;
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.CompanyNumber = reader.GetString(reader.GetOrdinal("companyNumber"));
connect2List.Add(temp);
}
conn.Close();
}
catch (Exception ee)
{
exception = ee.ToString();
//Console.WriteLine(ee.ToString());
}
//Console.WriteLine(image.ToString());
return(connect2List);
}
