protected void BtnModify_Click(object sender, EventArgs e)
{
//主表信息
MainInfoTab MainInfo = new MainInfoTab();
MainInfo.Id = Convert.ToInt32(Request.QueryString["MainId"].ToString());
//标题
MainInfo.Title = txtTitle.Value.Trim();
//会员名
MainInfo.MemberId = "会员名";
//类别
MainInfo.Types = Convert.ToInt32(txtTypes.SelectedValue);
//子表信息
DetailTab Detail = new DetailTab();
//联系电话
Detail.TelePhone = txtTelePhone.Value.Trim();
//邮箱
Detail.Email = txtEmail.Value;
//联系人
Detail.LinkMan = txtLinkMan.Value;
//来源(1->业主,2->需求)
Detail.Source = Convert.ToInt32(txtSource.SelectedValue);
//用途(1->门面,2->办公,3->商住两用)
Detail.Purpose = Convert.ToInt32(txtPurpose.SelectedValue);
//楼层(1->1-5楼,2->5-8楼,3->8楼以上)
Detail.Floor = Convert.ToInt32(txtFloor.SelectedValue);
//租金(1->40-60元/平方米,2->60-80元/平方米,3->80元以上)
Detail.Hire = Convert.ToInt32(txtHire.SelectedValue);
//面积(1->100平米以内,2->100-200平米,3->200平米以上)
Detail.Area = Convert.ToInt32(txtArea.SelectedValue);
//装修(1->简装,2->无,3->豪装)
Detail.Fitment = Convert.ToInt32(txtFitment.SelectedValue);
//电梯(1->有,2->无)
Detail.Elevator = Convert.ToInt32(txtElevator.SelectedValue);
string Types = Request.QueryString["Types"].ToString();
if (Types == "Modify")
{
if (bll.Modify(MainInfo, Detail))
{
Tz888.Common.MessageBox.ShowAndHref("修改成功!", "WyzsInfoManage.aspx");
}
else
{
Tz888.Common.MessageBox.ShowAndHref("修改成功!", "WyzsInfoManage.aspx");
}
}
else if (Types == "Checked")
{
}
}
protected void BtnSvae_Click(object sender, EventArgs e)
{
//主表信息
MainInfoTab MainInfo = new MainInfoTab();
//标题
MainInfo.Title = txtTitle.Value.Trim();
//会员名
MainInfo.MemberId = "会员名";
//类别
MainInfo.Types = Convert.ToInt32(txtTypes.SelectedValue);
//状态(1->可用,2->不可用)
MainInfo.State = 2;
//静态地址
MainInfo.Htmlurl = "";
//发布时间
MainInfo.PublishTime = DateTime.Now;
//子表信息
DetailTab Detail = new DetailTab();
//联系电话
Detail.TelePhone = txtTelePhone.Value.Trim();
//邮箱
Detail.Email = txtEmail.Value;
//联系人
Detail.LinkMan = txtLinkMan.Value;
//来源(1->业主,2->需求)
Detail.Source = Convert.ToInt32(txtSource.SelectedValue);
//用途(1->门面,2->办公,3->商住两用)
Detail.Purpose = Convert.ToInt32(txtPurpose.SelectedValue);
//楼层(1->1-5楼,2->5-8楼,3->8楼以上)
Detail.Floor = Convert.ToInt32(txtFloor.SelectedValue);
//租金(1->40-60元/平方米,2->60-80元/平方米,3->80元以上)
Detail.Hire = Convert.ToInt32(txtHire.SelectedValue);
//面积(1->100平米以内,2->100-200平米,3->200平米以上)
Detail.Area = Convert.ToInt32(txtArea.SelectedValue);
//装修(1->简装,2->无,3->豪装)
Detail.Fitment = Convert.ToInt32(txtFitment.SelectedValue);
//电梯(1->有,2->无)
Detail.Elevator = Convert.ToInt32(txtElevator.SelectedValue);
if (bll.Add(MainInfo, Detail))
{
Tz888.Common.MessageBox.ShowAndHref("添加成功!", "WyzsInfoManage.aspx");
}
else
{
Tz888.Common.MessageBox.ShowAndHref("添加失败!", "WyzsInfoManage.aspx");
}
}
private void InitWorkspaces()
{
//워크스페이스 생성
workspaces = new Workspace[] {
new Workspace(UiWorkspace, UiWorkspaceButton),
new Workspace(MotionWorkspace, MotionWorkspaceButton),
new Workspace(StoryWorkspace, StoryWorkspaceButton),
};
foreach (Workspace workspace in workspaces)
{
if (workspace.context.Parent == null)
{
WorkspaceContext.Children.Add(workspace.context);
}
}
WorkspaceContext.Visibility = Visibility.Collapsed;
//공통 탭 설정
AssetTab = UiWorkspace.AssetTab;
ViewportTab = UiWorkspace.ViewportTab;
DetailTab = UiWorkspace.DetailTab;
commonTabs = new UserControl[] {
AssetTab,
ViewportTab,
DetailTab,
};
//Invoke PostInit
needPostInitTabs = new INeedPostInitTab[] {
DetailTab,
};
foreach (INeedPostInitTab tab in needPostInitTabs)
{
tab.PostInit();
}
}
private void SelectedItemSet_SelectionRemoved(ITreeItem item)
{
SelectionChanged();
DetailTab.DeactiveDetailPanel();
}
//이게 두번 호출되는 버그가 있다
//그건 바로 Window.Loaded가 두번 호출되는 버그여따.
private void SelectedItemSet_SelectionAdded(ITreeItem item)
{
SelectionChanged();
DetailTab.ActiveDetailPanel(DetailPanelType.StoryBlock);
}
private void SelectedItemSet_SelectionRemoved(GKit.WPF.UI.Controls.ITreeItem item)
{
SelectionChanged();
DetailTab.DeactiveDetailPanel();
}
private void SelectedItemSet_SelectionAdded(GKit.WPF.UI.Controls.ITreeItem item)
{
SelectionChanged();
DetailTab.ActiveDetailPanel(DetailPanelType.UiItem);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="MainInfo"></param>
/// <returns></returns>
public bool Modify(MainInfoTab MainInfo, DetailTab Detail)
{
SqlParameter[] Paras = new SqlParameter[] {
//--主表信息
//@Title varchar(200),--标题
new SqlParameter("@Title", SqlDbType.VarChar, 200),
//@MemberId varchar(50),--会员ID
new SqlParameter("@MemberId", SqlDbType.VarChar, 50),
//@Types int,--标志(1->求租HireTab 2->购买BuyTab 3->出租LettingTab 4->出售SaleTab)
new SqlParameter("@Types", SqlDbType.Int),
//@State int,--状态(1->可用,2->不可用)
new SqlParameter("@State", SqlDbType.Int),
//@Htmlurl varchar(200),--静态页面地址
new SqlParameter("@Htmlurl", SqlDbType.VarChar, 200),
//@PublishTime dateTime,--发布时间
//new SqlParameter("@PublishTime",SqlDbType.DateTime),
//--子表信息
//@TelePhone varchar(50),--联系电话
new SqlParameter("@TelePhone", SqlDbType.VarChar, 50),
//@Email varchar(50),--邮箱
new SqlParameter("@Email", SqlDbType.VarChar, 50),
//@LinkMan varchar(50),--联系人
new SqlParameter("@LinkMan", SqlDbType.VarChar, 50),
//@Source int,--来源
new SqlParameter("@Source", SqlDbType.Int),
//@Purpose int,--用途(1->门面,2->办公,3->商住两用)
new SqlParameter("@Purpose", SqlDbType.Int),
//@Floor int,--楼层(1->1-5楼,2->5-8楼,3->8楼以上)
new SqlParameter("@Floor", SqlDbType.Int),
//@Hire int,--租金(1->40-60元/平方米,2->60-80元/平方米,3->80元以上)
new SqlParameter("@Hire", SqlDbType.Int),
//@Fitment int,--面积(1->100平米以内,2->100-200平米,3->200平米以上)
new SqlParameter("@Area", SqlDbType.Int),
//@Elevator int--装修(1->简装,2->无,3->豪装)
new SqlParameter("@Fitment", SqlDbType.Int),
//电梯(1->有,2->无)
new SqlParameter("@Elevator", SqlDbType.Int),
//MainId
new SqlParameter("@MainId", SqlDbType.Int)
};
Paras[0].Value = MainInfo.Title;
Paras[1].Value = MainInfo.MemberId;
Paras[2].Value = MainInfo.Types;
Paras[3].Value = MainInfo.State;
Paras[4].Value = MainInfo.Htmlurl;
//Paras[5].Value = MainInfo.PublishTime;
Paras[5].Value = Detail.TelePhone;
Paras[6].Value = Detail.Email;
Paras[7].Value = Detail.LinkMan;
Paras[8].Value = Detail.Source;
Paras[9].Value = Detail.Purpose;
Paras[10].Value = Detail.Floor;
Paras[11].Value = Detail.Hire;
Paras[12].Value = Detail.Area;
Paras[13].Value = Detail.Fitment;
Paras[14].Value = Detail.Elevator;
Paras[15].Value = MainInfo.Id;
int row = DBHelper.ExecuteNonQueryProc("ProModify", Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="MainInfo"></param>
/// <returns></returns>
public bool Modify(MainInfoTab MainInfo, DetailTab Detail)
{
return(dal.Modify(MainInfo, Detail));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="MainInfo"></param>
/// <returns></returns>
public bool Add(MainInfoTab MainInfo, DetailTab Detail)
{
return(dal.Add(MainInfo, Detail));
}
