/// <summary>
/// 新增流程类型
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int AddFlowCategory(FLOW_FLOWCATEGORY entity)
{
try
{
//string sql = "INSERT INTO FLOW_FLOWCATEGORY ( FLOWCATEGORYID,FLOWCATEGORYDESC) VALUES ('" + entity.FLOWCATEGORYID + "','" + entity.FLOWCATEGORYDESC + "' )";
//
//int result = dao.ExecuteNonQuery(sql);
//return result;
string insSql = "INSERT INTO FLOW_FLOWCATEGORY (FLOWCATEGORYID,FLOWCATEGORYDESC,COMPANYID) VALUES (:FLOWCATEGORYID,:FLOWCATEGORYDESC,:COMPANYID)";
Parameter[] pageparm =
{
new Parameter(":FLOWCATEGORYID",GetValue(entity.FLOWCATEGORYID)), //流程分类ID
new Parameter(":FLOWCATEGORYDESC",GetValue(entity.FLOWCATEGORYDESC)), //流程分类描述
new Parameter(":COMPANYID",GetValue(entity.COMPANYID)) //公司ID
};
ParameterCollection pras = new ParameterCollection();
foreach (var item in pageparm)
{
pras.Add(item);
}
int result = dao.ExecuteNonQuery(insSql, System.Data.CommandType.Text, pras);
return result;
}
catch (Exception ex)
{
Log.WriteLog(this, "AddFlowCategory()", "新增流程类型", ex);
return 0;
}
finally
{
}
}
/// <summary>
/// 修改流程类型
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int UpdateFlowCategory(FLOW_FLOWCATEGORY entity)
{
return flowcategory.UpdateFlowCategory(entity);
}
/// <summary>
/// 新增流程类型
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int AddFlowCategory(FLOW_FLOWCATEGORY entity)
{
return flowcategory.AddFlowCategory(entity);
}
/// <summary>
/// 修改流程类型
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int UpdateFlowCategory(FLOW_FLOWCATEGORY entity)
{
try
{
// string sql = "UPDATE FLOW_FLOWCATEGORY SET FLOWCATEGORYDESC='" + entity.FLOWCATEGORYDESC + "' WHERE FLOWCATEGORYID= '" + entity.FLOWCATEGORYID + "'";
string updSql = "UPDATE FLOW_FLOWCATEGORY SET FLOWCATEGORYDESC=:FLOWCATEGORYDESC WHERE FLOWCATEGORYID=:FLOWCATEGORYID";
Parameter[] pageparm =
{
new Parameter(":FLOWCATEGORYID",GetValue(entity.FLOWCATEGORYID)), //流程分类ID
new Parameter(":FLOWCATEGORYDESC",GetValue(entity.FLOWCATEGORYDESC)) //流程分类描述
};
ParameterCollection pras = new ParameterCollection();
foreach (var item in pageparm)
{
pras.Add(item);
}
int result = dao.ExecuteNonQuery(updSql, System.Data.CommandType.Text, pras);
return result;
}
catch (Exception ex)
{
Log.WriteLogFrist(this, "UpdateFlowCategory()", "修改流程类型", ex);
return 0;
}
finally
{
}
}