| | |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | sql = @"select * from TOrganization where parent_id=@orgid"; |
|---|
| | | sql = @"select * from TOrganization where parent_id=@orgid and is_delete<>'1'"; |
|---|
| | | dynamicParams.Add(@"orgid", orgid); |
|---|
| | | cont = DapperHelper.selectcount(sql, dynamicParams); |
|---|
| | | if (cont>0) |
|---|
| | |
|---|
| | | { |
|---|
| | | if (OperType == "Add") |
|---|
| | | { |
|---|
| | | var sql0 = @"select * from TCustomer where code=@code"; |
|---|
| | | var sql0 = @"select * from TCustomer where code=@unitcode"; |
|---|
| | | dynamicParams.Add("@unitcode", unitcode); |
|---|
| | | var data = DapperHelper.selectdata(sql0, dynamicParams); |
|---|
| | | if (data.Rows.Count > 0) |
|---|
