/// <summary>
/// 删除派工单，同时删除其中包含的附件
/// 上传派工单的日志和日志包含的附件
/// </summary>
/// <param name="guidid"></param>
/// <returns></returns>
public bool DeleteData(String guidid)
{
bool succ = false;
JConnect.GetConnect().BeginTrans();
try
{
//1--删除派工单
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("Guidid", guidid));
Tb_TaskDA da1 = new Tb_TaskDA();
DataRow dr1 = da1.GetFirstDataRow(condition, "*");
if (dr1 != null)
{
//删除相关附件
String filename1 = dr1["RelaFile"].ToString();
if (String.IsNullOrEmpty(filename1) == false)
{
filename1 = System.Web.HttpContext.Current.Server.MapPath(filename1);
if (File.Exists(filename1))
{
File.Delete(filename1);
}
}
//删除数据
da1.DeleteData(condition);
}
//2--删除派工单的日志
condition.Clear();
condition.Add(new SearchField("parentGuid", guidid));
Tb_Task_LogDA da2 = new Tb_Task_LogDA();
DataTable dt1 = da2.GetListData(condition, -1, -1, "", "*");
foreach (DataRow dr0 in dt1.Rows)
{
String filename1 = dr0["RelateFile"].ToString();
if (String.IsNullOrEmpty(filename1) == false)
{
filename1 = System.Web.HttpContext.Current.Server.MapPath(filename1);
if (File.Exists(filename1))
{
File.Delete(filename1);
}
}
}
da2.DeleteData(condition);
JConnect.GetConnect().CommitTrans();
succ = true;
}
catch (Exception err)
{
JConnect.GetConnect().RollBackTrans();
WebFrame.Util.JTool.WriteErrorLog(err.ToString());
}
return(succ);
}
public int NewLog(String ProjectGuidID,
String Stitle, String Content, String Kind,
System.Web.UI.WebControls.FileUpload f1,
ref String RelateFile, ref String RelaTrueName)
{
int succ = 0;
String FileDir = "/Attachment/UseAttachment/";
String truename1 = String.Empty;
bool saveFile = false;
try
{
Dictionary <String, object> dic1 = new Dictionary <string, object>();
dic1["guidID"] = WebFrame.Util.JString.GetUnique32ID();
dic1["parentGuid"] = ProjectGuidID;
dic1["Stitle"] = Stitle;
if (String.IsNullOrEmpty(Content) == false)
{
dic1["Content"] = (new StringBuilder()).Append(Content);
}
dic1["AddTime"] = DateTime.Now;
dic1["AddUserID"] = WebFrame.FrameLib.UserID;
dic1["AddUserNet"] = WebFrame.FrameLib.UserName;
dic1["kind"] = Kind;
if (f1 != null && f1.HasFile)
{
String ext1 = Path.GetExtension(f1.FileName);
truename1 = WebFrame.Util.JString.GetUnique32ID() + ext1;
f1.SaveAs(System.Web.HttpContext.Current.Server.MapPath(FileDir + truename1));
dic1["RelateFile"] = FileDir + truename1;
dic1["RelaTrueName"] = Path.GetFileName(f1.FileName);
//文件名和文件路径
RelateFile = dic1["RelateFile"].ToString();
RelaTrueName = dic1["RelaTrueName"].ToString();
saveFile = true;
}
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
da1.NewData(dic1);
succ = 1;
}
catch (Exception err)
{
//删除已上传的文件
if (saveFile && File.Exists(System.Web.HttpContext.Current.Server.MapPath(FileDir + truename1)))
{
File.Delete(System.Web.HttpContext.Current.Server.MapPath(FileDir + truename1));
}
throw err;
}
return(succ);
}
/// <summary>
/// 功能：执行普通的SQL语句
/// </summary>
public void ExcuteSql(String sql)
{
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
da1.ExcuteSql(sql);
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 根据条件，修改一个数据
/// </summary>
/// <param name="condition">修改数据的条件</param>
/// <param name="data1">新的数据</param>
public void EditData(List <SearchField> condition, Dictionary <String, object> data1)
{
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
da1.EditData(condition, data1);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 根据条件删除数据
/// </summary>
/// <param name="condition">删除数据条件</param>
public void DeleteData(List <SearchField> condition)
{
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
da1.DeleteData(condition);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 新增一条数据
/// </summary>
/// <param name="data1">Dictionary数据</param>
public void NewData(Dictionary <String, object> data1)
{
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
da1.NewData(data1);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
}
/// <summary>
/// 判断是否有符合条件的数据
/// </summary>
///<param name="condition">查询条件</param>
/// <returns></returns>
public bool HasData(List <SearchField> condition)
{
bool result = false;
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
result = da1.HasData(condition);
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
return(result);
}
/// <summary>
/// 得到满足条件的第一行数据(返回值为Dictionary)
/// </summary>
/// <param name="condition">查询条件</param>
/// <param name="Fields">数据字段</param>
/// <returns>Dictionary字典</returns>
public Dictionary <string, object> GetFirstDictionary(List <SearchField> condition, params String[] Fields)
{
Dictionary <string, object> data1 = null;
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
data1 = da1.GetFirstDictionary(condition, Fields);
this.executeResultCount = da1.ExecuteResultCount;
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
return(data1);
}
/// <summary>
/// 得到日志的数量
/// </summary>
/// <param name="ParentGuidid"></param>
/// <returns></returns>
public static int GetLogCount(String ParentGuidid)
{
int result = 0;
if (String.IsNullOrEmpty(ParentGuidid) == false)
{
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("TaskID", ParentGuidid));
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
DataRow dr1 = da1.GetFirstDataRow(condition, "count(*) as count0");
if (dr1 != null)
{
result = int.Parse(dr1[0].ToString());
}
}
return(result);
}
/// <summary>
/// 根据条件得到列表数据
/// </summary>
/// <param name="condition">查询条件</param>
/// <param name="PageSize">页大小</param>
/// <param name="CurPage">当前页</param>
/// <param name="Fields">数据字段</param>
/// <param name="orderBy">排序表达式</param>
/// <param name="TotalRow">数据总行数</param>
/// <param name="Fields">要显示的字段</param>
/// <returns>列表数据</returns>
public DataTable GetListData(List <SearchField> condition,
int PageSize, int CurPage, String orderBy,
out int TotalRow, params String[] Fields)
{
TotalRow = 0;
DataTable dt1 = null;
try
{
Tb_Task_LogDA da1 = new Tb_Task_LogDA();
dt1 = da1.GetListData(condition, PageSize, CurPage, orderBy, out TotalRow, Fields);
this.executeResultCount = da1.ExecuteResultCount;
return(dt1);
}
catch (Exception err)
{
this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", "");
}
return(dt1);
}
