/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Company_Point GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WinpointIniPath,PointFieldIDMappingFile,CardexFile,PointImportIntervalMinutes from Company_Point ");
//strSql.Append(" where ");
SqlParameter[] parameters =
{
};
LPWeb.Model.Company_Point model = new LPWeb.Model.Company_Point();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.WinpointIniPath = ds.Tables[0].Rows[0]["WinpointIniPath"].ToString();
model.PointFieldIDMappingFile = ds.Tables[0].Rows[0]["PointFieldIDMappingFile"].ToString();
model.CardexFile = ds.Tables[0].Rows[0]["CardexFile"].ToString();
if (ds.Tables[0].Rows[0]["PointImportIntervalMinutes"].ToString() != "")
{
model.PointImportIntervalMinutes = int.Parse(ds.Tables[0].Rows[0]["PointImportIntervalMinutes"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Company_Point model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Company_Point set ");
strSql.Append("WinpointIniPath=@WinpointIniPath,");
strSql.Append("PointFieldIDMappingFile=@PointFieldIDMappingFile,");
strSql.Append("CardexFile=@CardexFile,");
strSql.Append("PointImportIntervalMinutes=@PointImportIntervalMinutes,");
strSql.Append("MasterSource=@MasterSource,");
strSql.Append("TracToolsLogin=@TracToolsLogin,");
strSql.Append("TracToolsPwd=@TracToolsPwd,");
strSql.Append("Auto_ConvertLead=@Auto_ConvertLead,");
strSql.Append("AutoApplyProcessingWorkflow=@AutoApplyProcessingWorkflow,");
strSql.Append("AutoApplyProspectWorkflow=@AutoApplyProspectWorkflow,");
strSql.Append("Enable_MultiBranchFolders=@Enable_MultiBranchFolders");
//strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@WinpointIniPath", SqlDbType.NVarChar, 255),
new SqlParameter("@PointFieldIDMappingFile", SqlDbType.NVarChar, 255),
new SqlParameter("@CardexFile", SqlDbType.NVarChar, 255),
new SqlParameter("@PointImportIntervalMinutes", SqlDbType.SmallInt, 2),
new SqlParameter("@MasterSource", SqlDbType.NVarChar, 50),
new SqlParameter("@TracToolsLogin", SqlDbType.NVarChar, 50),
new SqlParameter("@TracToolsPwd", SqlDbType.NVarChar, 25),
new SqlParameter("@Auto_ConvertLead", SqlDbType.Bit),
new SqlParameter("@AutoApplyProcessingWorkflow", SqlDbType.Bit),
new SqlParameter("@AutoApplyProspectWorkflow", SqlDbType.Bit),
new SqlParameter("@Enable_MultiBranchFolders", SqlDbType.Bit)
};
parameters[0].Value = model.WinpointIniPath;
parameters[1].Value = model.PointFieldIDMappingFile;
parameters[2].Value = model.CardexFile;
parameters[3].Value = model.PointImportIntervalMinutes;
parameters[4].Value = model.MasterSource;
parameters[5].Value = model.TracToolsLogin;
parameters[6].Value = model.TracToolsPwd;
parameters[7].Value = model.Auto_ConvertLead;
parameters[8].Value = model.AutoApplyProcessingWorkflow;
parameters[9].Value = model.AutoApplyProspectWorkflow;
parameters[10].Value = model.Enable_MultiBranchFolders;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(LPWeb.Model.Company_Point model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Company_Point(");
strSql.Append("WinpointIniPath,PointFieldIDMappingFile,CardexFile,PointImportIntervalMinutes)");
strSql.Append(" values (");
strSql.Append("@WinpointIniPath,@PointFieldIDMappingFile,@CardexFile,@PointImportIntervalMinutes)");
SqlParameter[] parameters =
{
new SqlParameter("@WinpointIniPath", SqlDbType.NVarChar, 255),
new SqlParameter("@PointFieldIDMappingFile", SqlDbType.NVarChar, 255),
new SqlParameter("@CardexFile", SqlDbType.NVarChar, 255),
new SqlParameter("@PointImportIntervalMinutes", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.WinpointIniPath;
parameters[1].Value = model.PointFieldIDMappingFile;
parameters[2].Value = model.CardexFile;
parameters[3].Value = model.PointImportIntervalMinutes;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Company_Point GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WinpointIniPath,PointFieldIDMappingFile,CardexFile,PointImportIntervalMinutes,MasterSource,TracToolsLogin,TracToolsPwd,Auto_ConvertLead,AutoApplyProcessingWorkflow,AutoApplyProspectWorkflow,Enable_MultiBranchFolders from Company_Point ");
//strSql.Append(" where ");
SqlParameter[] parameters =
{
};
LPWeb.Model.Company_Point model = new LPWeb.Model.Company_Point();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.WinpointIniPath = ds.Tables[0].Rows[0]["WinpointIniPath"].ToString();
model.PointFieldIDMappingFile = ds.Tables[0].Rows[0]["PointFieldIDMappingFile"].ToString();
model.CardexFile = ds.Tables[0].Rows[0]["CardexFile"].ToString();
if (ds.Tables[0].Rows[0]["PointImportIntervalMinutes"].ToString() != "")
{
model.PointImportIntervalMinutes = int.Parse(ds.Tables[0].Rows[0]["PointImportIntervalMinutes"].ToString());
}
model.MasterSource = ds.Tables[0].Rows[0]["MasterSource"] != null ? ds.Tables[0].Rows[0]["MasterSource"].ToString() : "";
model.TracToolsLogin = ds.Tables[0].Rows[0]["TracToolsLogin"] != null ? ds.Tables[0].Rows[0]["TracToolsLogin"].ToString() : "";
model.TracToolsPwd = ds.Tables[0].Rows[0]["TracToolsPwd"] != null ? ds.Tables[0].Rows[0]["TracToolsPwd"].ToString() : "";
model.Auto_ConvertLead = ds.Tables[0].Rows[0]["Auto_ConvertLead"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Auto_ConvertLead"]) : false;
model.AutoApplyProcessingWorkflow = ds.Tables[0].Rows[0]["AutoApplyProcessingWorkflow"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["AutoApplyProcessingWorkflow"]) : false;
model.AutoApplyProspectWorkflow = ds.Tables[0].Rows[0]["AutoApplyProspectWorkflow"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["AutoApplyProspectWorkflow"]) : false;
model.Enable_MultiBranchFolders = ds.Tables[0].Rows[0]["Enable_MultiBranchFolders"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Enable_MultiBranchFolders"]) : false;
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Company_Point model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Company_Point set ");
strSql.Append("WinpointIniPath=@WinpointIniPath,");
strSql.Append("PointFieldIDMappingFile=@PointFieldIDMappingFile,");
strSql.Append("CardexFile=@CardexFile,");
strSql.Append("PointImportIntervalMinutes=@PointImportIntervalMinutes");
//strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@WinpointIniPath", SqlDbType.NVarChar, 255),
new SqlParameter("@PointFieldIDMappingFile", SqlDbType.NVarChar, 255),
new SqlParameter("@CardexFile", SqlDbType.NVarChar, 255),
new SqlParameter("@PointImportIntervalMinutes", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.WinpointIniPath;
parameters[1].Value = model.PointFieldIDMappingFile;
parameters[2].Value = model.CardexFile;
parameters[3].Value = model.PointImportIntervalMinutes;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(LPWeb.Model.Company_Point model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Company_Point(");
strSql.Append("WinpointIniPath,PointFieldIDMappingFile,CardexFile,PointImportIntervalMinutes,MasterSource,TracToolsLogin,TracToolsPwd,Auto_ConvertLead,AutoApplyProcessingWorkflow,AutoApplyProspectWorkflow,Enable_MultiBranchFolders)");
strSql.Append(" values (");
strSql.Append("@WinpointIniPath,@PointFieldIDMappingFile,@CardexFile,@PointImportIntervalMinutes,@MasterSource,@TracToolsLogin,@TracToolsPwd,@Auto_ConvertLead,@AutoApplyProcessingWorkflow,@AutoApplyProspectWorkflow,@Enable_MultiBranchFolders)");
SqlParameter[] parameters =
{
new SqlParameter("@WinpointIniPath", SqlDbType.NVarChar, 255),
new SqlParameter("@PointFieldIDMappingFile", SqlDbType.NVarChar, 255),
new SqlParameter("@CardexFile", SqlDbType.NVarChar, 255),
new SqlParameter("@PointImportIntervalMinutes", SqlDbType.SmallInt, 2),
new SqlParameter("@MasterSource", SqlDbType.NVarChar, 50),
new SqlParameter("@TracToolsLogin", SqlDbType.NVarChar, 50),
new SqlParameter("@TracToolsPwd", SqlDbType.NVarChar, 25),
new SqlParameter("@Auto_ConvertLead", SqlDbType.Bit),
new SqlParameter("@AutoApplyProcessingWorkflow", SqlDbType.Bit),
new SqlParameter("@AutoApplyProspectWorkflow", SqlDbType.Bit),
new SqlParameter("@Enable_MultiBranchFolders", SqlDbType.Bit)
};
parameters[0].Value = model.WinpointIniPath;
parameters[1].Value = model.PointFieldIDMappingFile;
parameters[2].Value = model.CardexFile;
parameters[3].Value = model.PointImportIntervalMinutes;
parameters[4].Value = model.MasterSource;
parameters[5].Value = model.TracToolsLogin;
parameters[6].Value = model.TracToolsPwd;
parameters[7].Value = model.Auto_ConvertLead;
parameters[8].Value = model.AutoApplyProcessingWorkflow;
parameters[9].Value = model.AutoApplyProspectWorkflow;
parameters[10].Value = model.Enable_MultiBranchFolders;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
