/// <summary>
/// 导出数据
/// </summary>
/// <param name="mod"></param>
public void ImportOut()
{
string hearder = "二维码编号,图片,箱子位置,查询简码,添加时间";
string column = "QrCode,Img,Address,Name,CreateTime";
title = hearder.Split(','); //导出的标题
field = column.Split(','); //导出对应字段
var search = base.GetSearch();
try
{
string IdList = Request["IdList"].ToString();
search.AddCondition("Id in(" + IdList + ")");//过滤选中的记录
search.AddCondition("Status!=" + (int)StatusEnum.除);
DataTable ds = new BllSysQRCode().GetList("Fire_FireBox", " and " + search.GetConditon(), "", 0).Tables[0];
if (ds.Rows.Count > 0)
{
ToExcel(ds);
}
LogInsert(OperationTypeEnum.操作, "箱子二维码导出", "二维码导出成功.");
}
catch (Exception ex)
{
LogInsert(OperationTypeEnum.异常, "箱子二维码导出", "操作异常信息:" + ex);
}
}
/// <summary>
/// 删除
/// </summary>
public void LoadData()
{
string id = Request["id"].ToString();
var msg = new ModJsonResult();
var model = new BllSysQRCode().LoadData(id);
WriteJsonToPage(new JavaScriptSerializer().Serialize(model));
}
public void SaveData()
{
BllSysQRCode bll = new BllSysQRCode();
ModJsonResult json = new ModJsonResult();
ModSysQRCode t = new ModSysQRCode();
try
{
string GroupName = DateTimeHelper.DateTimeToUnixTimestamp(DateTime.Now).ToString();//时间戳进行分组
int CountNum = int.Parse(Request["CountNum"].ToString());
int resultCount = 0;
for (int i = 0; i < CountNum; i++)
{
resultCount++;
t.Id = Guid.NewGuid().ToString();
t.Name = GroupName + resultCount.ToString("00000"); //二维码编号
t.GroupName = GroupName; //二维码分组
t.Status = (int)StatusEnum.禁用;
t.Img = QrCode(t.Id + "S"); //设备二维码最后大写S
t.QrCode = t.Id;
t.SysId = CurrentMaster.Cid;
t.CreateTime = DateTime.Now; //创建时间
t.CreaterId = CurrentMaster.Id; //创建人编号
int result = bll.Insert(t);
}
if (resultCount <= 0)
{
json.success = false;
json.msg = "生成失败,请稍后再操作!";
LogInsert(OperationTypeEnum.操作, "批量二维码", "生成失败.");
}
else
{
LogInsert(OperationTypeEnum.操作, "批量二维码", "生成成功.");
}
}
catch (Exception ex)
{
LogInsert(OperationTypeEnum.异常, "批量二维码", "操作异常信息:" + ex);
}
WriteJsonToPage(json.ToString());
}
/// <summary>
/// 删除
/// </summary>
public void DeleteData(string id)
{
var msg = new ModJsonResult();
try
{
//判断该品牌是否还在使用
BllSysQRCode Bll = new BllSysQRCode();
DataSet ds = Bll.CanDelete(id);
int can = 0;
if (ds.Tables[0].Rows.Count > 0)
{
can = int.Parse(ds.Tables[0].Rows[0]["DocumentCount"].ToString());
can += int.Parse(ds.Tables[0].Rows[0]["ElevatorCount"].ToString());
can += int.Parse(ds.Tables[0].Rows[0]["CompanyCount"].ToString());
}
if (can > 0)
{
msg.success = false;
msg.msg = "该品牌正在使用,不能删除";
}
else
{
int result = new BllSysQRCode().DeleteStatus(id);
if (result > 0)
{
msg.success = true;
}
else
{
msg.success = false;
msg.msg = "操作失败";
}
}
}
catch (Exception ex)
{
msg.msg = "操作失败：" + ex.Message;
}
WriteJsonToPage(msg.ToString());
}
/// <summary>
/// 根据id 加载数据
/// </summary>
public JsonResult SearchData()
{
var search = base.GetSearch();
if (!string.IsNullOrEmpty(Request["BrandName"]))
{
search.AddCondition(" and (Name like '%" + Request["BrandName"].ToString() + "%' or Jianpin like '%" + Request["BrandName"].ToString() + "%')");
}
if (!CurrentMaster.IsMain)
{
if (CurrentMaster.LookPower == (int)LookPowerEnum.查看自建)
{
search.AddCondition(" and CreaterId='" + CurrentMaster.Id + "'");
}
}
IList <ModSysQRCode> list = new BllSysQRCode().GetSysIdList(CurrentMaster.Cid, search.GetConditon());
var json = new
{
rows = list
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除
/// </summary>
public void DeleteModelData(string id)
{
var msg = new ModJsonResult();
try
{
BllSysQRCode Bll = new BllSysQRCode();
if (Bll.DeleteStatus(id) > 0)
{
msg.success = true;
}
else
{
msg.success = false;
msg.msg = "操作失败";
}
}
catch (Exception ex)
{
msg.msg = "操作失败：" + ex.Message;
}
WriteJsonToPage(msg.ToString());
}
public void SaveData(ModSysQRCode t)
{
BllSysQRCode bll = new BllSysQRCode();
ModJsonResult json = new ModJsonResult();
t.Status = (int)StatusEnum.正常;
//获取文件
HttpPostedFileBase postedFile = Request.Files["ImageUrl"];
string filename = postedFile.FileName;//获取上传的文件路径
string configPath = System.Configuration.ConfigurationManager.AppSettings["ChannelManager"];
string str = "";
string path = "";//文件路径
bool succ = true;
if (!String.IsNullOrEmpty(filename) || (!string.IsNullOrEmpty(Request["modify"]) && !string.IsNullOrEmpty(Request["isUpLoad"])))
{
if (new PicFileUpLoad().UpLoad("Advertise", postedFile, configPath, filename, out path, out str))
{
t.Img = path;
}
else
{
succ = false;
}
}
if (succ)
{
if (!string.IsNullOrEmpty(Request["modify"])) //修改
{
var Category = bll.LoadData(t.Id);
if (!String.IsNullOrEmpty(t.Img))
{
Category.Img = t.Img;
}
Category.Name = t.Name;
int result = bll.EditData(Category);
if (result <= 0)
{
json.success = false;
json.msg = "修改失败,请稍后再操作!";
}
}
else
{
t.Id = Guid.NewGuid().ToString();
t.SysId = CurrentMaster.Cid;
t.CreateTime = DateTime.Now; //创建时间
t.CreaterId = CurrentMaster.Id; //创建人编号
int result = bll.InsertData(t);
if (result <= 0)
{
json.success = false;
json.msg = " 保存失败,请稍后再操作!";
}
}
}
else
{
json.success = false;
json.msg = "请上传正确的图片";
}
WriteJsonToPage(json.ToString());
}
