private void DataToWeb(ModelWebPublishModule m)
{
if (m.IsCookiesLogin == 1)
{
LoginedCookies = m.CookiesValue;
ViewCMS(m);
}
}
private void ViewCMS(ModelWebPublishModule m)
{
LoginPostData = mPublishModuleItem.ViewPostData;
string result = SimulationHelper.PostPage(m.SiteUrl + mPublishModuleItem.ViewUrl,
"",
m.SiteUrl + mPublishModuleItem.ViewRefUrl,
mPublishModuleItem.PageEncode,
ref LoginedCookies);
//
}
public List <ModelWebPublishModule> GetListModel(int TaskID)
{
List <ModelWebPublishModule> list = new List <ModelWebPublishModule>();
DataTable dt = this.GetList(" TaskID=" + TaskID + " ").Tables[0];
foreach (DataRow dr in dt.Rows)
{
ModelWebPublishModule model = this.GetModel(int.Parse("0" + dr["ID"]));
list.Add(model);
}
return(list);
}
private void btnSubmit_Click(object sender, EventArgs e)
{
int ID = Int32.Parse("0" + this.txtID.Text);
int TaskID = this.TaskID;
string ModuleName = this.txtWebPublishName.Text;
string SiteUrl = this.txtWebPublishUrl.Text;
int IsCookiesLogin = this.chkCookies.Checked ? 1 : 0;
string CookiesValue = this.txtWebPublishCookies.Text;
int ClassID = int.Parse(this.txtClassID.Text);
string ClassName = this.txtClassName.Text;
string LoginUserName = this.txtWebPublishUserName.Text;
string LoginUserPwd = this.txtWebPublishPassWord.Text;
string ModuleNameFile = (string)this.listBoxPublishModule.SelectedItem;
string CreateTime = DateTime.Now.ToString();
DALWebPublishModule dal = new DALWebPublishModule();
ModelWebPublishModule model = new ModelWebPublishModule();
model.ID = ID;
model.TaskID = TaskID;
model.ModuleName = ModuleName;
model.SiteUrl = SiteUrl;
model.IsCookiesLogin = IsCookiesLogin;
model.CookiesValue = CookiesValue;
model.ClassID = ClassID;
model.ClassName = ClassName;
model.LoginUserName = LoginUserName;
model.LoginUserPwd = LoginUserPwd;
model.ModuleNameFile = ModuleNameFile;
model.CreateTime = CreateTime;
if (ID == 0)
{
ID = dal.Add(model);
}
else if (ID > 0)
{
dal.Update(model);
}
if (ECEH != null)
{
ECEH(ID, "操作成功!");
}
this.Hide();
this.Close();
}
private void Bind_DataEdit()
{
ListView.SelectedListViewItemCollection item = (ListView.SelectedListViewItemCollection)EditItem;
DALWebPublishModule dal = new DALWebPublishModule();
int ID = Int32.Parse("0" + item[0].Tag);
ModelWebPublishModule model = dal.GetModel(ID);
this.txtID.Text = model.ID.ToString();
this.TaskID = int.Parse("0" + model.TaskID.ToString());
this.txtWebPublishName.Text = model.ModuleName;
this.txtWebPublishUrl.Text = model.SiteUrl;
this.chkCookies.Checked = model.IsCookiesLogin.ToString() == "1" ? true : false;
this.txtWebPublishCookies.Text = model.CookiesValue;
this.txtClassID.Text = model.ClassID.ToString();
this.txtClassName.Text = model.ClassName;
this.txtWebPublishUserName.Text = model.LoginUserName;
this.txtWebPublishPassWord.Text = model.LoginUserPwd;
this.listBoxPublishModule.SelectedItem = model.ModuleNameFile;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ModelWebPublishModule model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update S_WebPublishModule set ");
if (model.TaskID != null)
{
strSql.Append("TaskID=" + model.TaskID + ",");
}
else
{
strSql.Append("TaskID= null ,");
}
if (model.ModuleName != null)
{
strSql.Append("ModuleName='" + model.ModuleName + "',");
}
else
{
strSql.Append("ModuleName= null ,");
}
if (model.SiteUrl != null)
{
strSql.Append("SiteUrl='" + model.SiteUrl + "',");
}
else
{
strSql.Append("SiteUrl= null ,");
}
if (model.IsCookiesLogin != null)
{
strSql.Append("IsCookiesLogin="******",");
}
else
{
strSql.Append("IsCookiesLogin= null ,");
}
if (model.CookiesValue != null)
{
strSql.Append("CookiesValue='" + model.CookiesValue + "',");
}
else
{
strSql.Append("CookiesValue= null ,");
}
if (model.ClassID != null)
{
strSql.Append("ClassID=" + model.ClassID + ",");
}
else
{
strSql.Append("ClassID= null ,");
}
if (model.ClassName != null)
{
strSql.Append("ClassName='" + model.ClassName + "',");
}
else
{
strSql.Append("ClassName= null ,");
}
if (model.LoginUserName != null)
{
strSql.Append("LoginUserName='******',");
}
else
{
strSql.Append("LoginUserName= null ,");
}
if (model.LoginUserPwd != null)
{
strSql.Append("LoginUserPwd='" + model.LoginUserPwd + "',");
}
else
{
strSql.Append("LoginUserPwd= null ,");
}
if (model.ModuleNameFile != null)
{
strSql.Append("ModuleNameFile='" + model.ModuleNameFile + "',");
}
else
{
strSql.Append("ModuleNameFile= null ,");
}
if (model.CreateTime != null)
{
strSql.Append("CreateTime='" + model.CreateTime + "',");
}
else
{
strSql.Append("CreateTime= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ID=" + model.ID + "");
int rowsAffected = SQLiteHelper.Execute(dbStr, strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ModelWebPublishModule GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" ID,TaskID,ModuleName,SiteUrl,IsCookiesLogin,CookiesValue,ClassID,ClassName,LoginUserName,LoginUserPwd,ModuleNameFile,CreateTime ");
strSql.Append(" from S_WebPublishModule ");
strSql.Append(" where ID=" + ID + "");
ModelWebPublishModule model = new ModelWebPublishModule();
DataSet ds = SQLiteHelper.Query1(dbStr, strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["TaskID"].ToString() != "")
{
model.TaskID = int.Parse(ds.Tables[0].Rows[0]["TaskID"].ToString());
}
if (ds.Tables[0].Rows[0]["ModuleName"] != null)
{
model.ModuleName = ds.Tables[0].Rows[0]["ModuleName"].ToString();
}
if (ds.Tables[0].Rows[0]["SiteUrl"] != null)
{
model.SiteUrl = ds.Tables[0].Rows[0]["SiteUrl"].ToString();
}
if (ds.Tables[0].Rows[0]["IsCookiesLogin"].ToString() != "")
{
model.IsCookiesLogin = int.Parse(ds.Tables[0].Rows[0]["IsCookiesLogin"].ToString());
}
if (ds.Tables[0].Rows[0]["CookiesValue"] != null)
{
model.CookiesValue = ds.Tables[0].Rows[0]["CookiesValue"].ToString();
}
if (ds.Tables[0].Rows[0]["ClassID"].ToString() != "")
{
model.ClassID = int.Parse(ds.Tables[0].Rows[0]["ClassID"].ToString());
}
if (ds.Tables[0].Rows[0]["ClassName"] != null)
{
model.ClassName = ds.Tables[0].Rows[0]["ClassName"].ToString();
}
if (ds.Tables[0].Rows[0]["LoginUserName"] != null)
{
model.LoginUserName = ds.Tables[0].Rows[0]["LoginUserName"].ToString();
}
if (ds.Tables[0].Rows[0]["LoginUserPwd"] != null)
{
model.LoginUserPwd = ds.Tables[0].Rows[0]["LoginUserPwd"].ToString();
}
if (ds.Tables[0].Rows[0]["ModuleNameFile"] != null)
{
model.ModuleNameFile = ds.Tables[0].Rows[0]["ModuleNameFile"].ToString();
}
if (ds.Tables[0].Rows[0]["CreateTime"] != null)
{
model.CreateTime = ds.Tables[0].Rows[0]["CreateTime"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModelWebPublishModule model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.TaskID != null)
{
strSql1.Append("TaskID,");
strSql2.Append("" + model.TaskID + ",");
}
if (model.ModuleName != null)
{
strSql1.Append("ModuleName,");
strSql2.Append("'" + model.ModuleName + "',");
}
if (model.SiteUrl != null)
{
strSql1.Append("SiteUrl,");
strSql2.Append("'" + model.SiteUrl + "',");
}
if (model.IsCookiesLogin != null)
{
strSql1.Append("IsCookiesLogin,");
strSql2.Append("" + model.IsCookiesLogin + ",");
}
if (model.CookiesValue != null)
{
strSql1.Append("CookiesValue,");
strSql2.Append("'" + model.CookiesValue + "',");
}
if (model.ClassID != null)
{
strSql1.Append("ClassID,");
strSql2.Append("" + model.ClassID + ",");
}
if (model.ClassName != null)
{
strSql1.Append("ClassName,");
strSql2.Append("'" + model.ClassName + "',");
}
if (model.LoginUserName != null)
{
strSql1.Append("LoginUserName,");
strSql2.Append("'" + model.LoginUserName + "',");
}
if (model.LoginUserPwd != null)
{
strSql1.Append("LoginUserPwd,");
strSql2.Append("'" + model.LoginUserPwd + "',");
}
if (model.ModuleNameFile != null)
{
strSql1.Append("ModuleNameFile,");
strSql2.Append("'" + model.ModuleNameFile + "',");
}
if (model.CreateTime != null)
{
strSql1.Append("CreateTime,");
strSql2.Append("'" + model.CreateTime + "',");
}
strSql.Append("insert into S_WebPublishModule(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select LAST_INSERT_ROWID()");
object obj = SQLiteHelper.Execute(dbStr, strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
