private void initinfo(string strID)
{
pd_outbuykit ok = new pd_outbuykit();
DataTable dt = ok.getEditdata(strID);
DataRow r = dt.Rows[0];
editID.Text = strID;
oname.Text = r["oname"].ToString().Trim();
ocode.Text = r["ocode"].ToString().Trim();
specification.Text = r["specification"].ToString().Trim();
otype.Text = r["otype"].ToString();
imgPhoto.ImageUrl = ok.getPhotoFileName(strID) == "" ? DEFAULT_IMAGEPATH : IMAGEPATH + ok.getPhotoFileName(strID);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int[] intRowindexarray = Grid1.SelectedRowIndexArray;
if (intRowindexarray.Length > 0)
{
pd_outbuykit ok = new pd_outbuykit();
object[] keys = Grid1.DataKeys[intRowindexarray[0]];
string strID = keys[0].ToString();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("isdelid", "2");
string photoID = ok.getPhotoID(strID);
if (photoID != "")
{
// 返回与指定虚拟路径相对应的物理路径即绝对路径
string filePath = Server.MapPath(IMAGEPATH + ok.getPhotoFileName(strID));
// 删除该文件
System.IO.File.Delete(filePath);
int intresultPhoto = new pd_photo().delete("pd_photo", "ID", ok.getPhotoID(strID));
}
int intresult = ok.delete("pd_outbuykit", "ID", strID);
setPageContent(1);
Alert alert = new Alert();
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "成功移除数据";
}
else
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据移除失败";
}
alert.Show();
}
else
{
Alert.Show("请选择记录！");
}
}
private void BindGrid()
{
string stroname = Foname.Text.Trim();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("oname", stroname);
int intPageindex = Convert.ToInt32(CurPage.Text.Trim());
int intPagesize = Convert.ToInt32(GridPageSize.Text.Trim());
string strSort = Grid1.SortField;
string strSortDirection = Grid1.SortDirection;
pd_outbuykit ok = new pd_outbuykit();
DataTable dt = ok.getBindDataAsdt(dic, strSort, strSortDirection, intPagesize, intPageindex);
DataTable dt1 = ok.getBindDataAsdt(dic, strSort, strSortDirection);
TotalPage.Text = dt1.Rows.Count.ToString();
Grid1.DataSource = dt;
Grid1.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
Dictionary <string, string> dicOutBuykit = initDatadicOutBuykit();
Dictionary <string, string> dicPhoto = initDatadicPhoto();
string strID = editID.Text.ToString().Trim();
pd_outbuykit ok = new pd_outbuykit();
pd_photo ph = new pd_photo();
int intresultRecord = 0;
int intresultPhoto = 0;
if (strID == "")
{
string standardKitID = Guid.NewGuid().ToString();
dicOutBuykit.Add("ID", standardKitID);
dicOutBuykit.Add("isdelid", "1");
dicPhoto.Add("ID", Guid.NewGuid().ToString());
dicPhoto.Add("isdelid", "1");
dicPhoto.Add("pid", standardKitID);
string str_ocode = dicOutBuykit["ocode"].ToString().Trim();
string str_oname = dicOutBuykit["oname"].ToString().Trim();
if ((ok.isExistdata("pd_outbuykit", "ocode", str_ocode, "ocode").Trim() != "") || (ok.isExistdata("pd_outbuykit", "oname", str_oname, "oname").Trim() != ""))
{
Alert.Show(" 该外购件名称或代码已经存在!");
}
else
{
intresultRecord = ok.add(dicOutBuykit, "pd_outbuykit");
intresultPhoto = 1;
if ((filePhoto.HasFile) && (intresultRecord == 1))
{
intresultPhoto = ph.add(dicPhoto, "pd_photo");
}
}
}
else
{
intresultRecord = ok.update(dicOutBuykit, "pd_outbuykit", "ID", strID);
//exist photo->update || else ->add
string photoID = ok.getPhotoID(strID).Trim();
if (intresultRecord == 1)
{
if (photoID != "")
{
// 返回与指定虚拟路径相对应的物理路径即绝对路径
string filePath = Server.MapPath(IMAGEPATH + ok.getPhotoFileName(strID));
// 删除该文件
System.IO.File.Delete(filePath);
intresultPhoto = ph.update(dicPhoto, "pd_photo", "ID", photoID);
}
else
{
dicPhoto.Add("ID", Guid.NewGuid().ToString());
dicPhoto.Add("isdelid", "1");
dicPhoto.Add("pid", strID);
intresultPhoto = ph.add(dicPhoto, "pd_photo");
}
}
}
if (CurPage.Text.Trim() == "")
{
setPageContent(1);
}
else
{
setPageContent(5);
}
Alert alert = new Alert();
if ((intresultRecord == 1) && (intresultPhoto == 1))
{
alert.Icon = Icon.Information;
alert.Message = "数据保存成功";
imgPhoto.Reset();
filePhoto.Reset();
}
else if (intresultRecord == 0)
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据保存失败";
filePhoto.Reset();
imgPhoto.Reset();
}
else if (intresultPhoto == 0)
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "图片保存失败";
filePhoto.Reset();
imgPhoto.Reset();
}
alert.Show();
}
